Snowflake Connector in Looker Studio

Looker Q&A Looker
1

I’ve been trying to connect snowflake connctor to looker studio.

  1. Our orgnization changed to SSO in Snowflake and we no longer have a password to login.

  2. I have a dedicated service user account to connect Snowflake to Looker Studio and here, I had to use RSA Key Pair.

  3. While using Community Connector, I can only see username/password pattern but no the Key-Pair Authentication. So, all this time, I have been using my unencrypted private key as the password (without headers and footers).

It works good sometimes and suddenly the connection falls out giving me “Couldn’t obtain the token“ or “JWT_TOKEN_INAVLID_EXPIRATION_TIME“ errors.

Is there any clean set up to avoid these errors?

Thanks in advance :slight_smile: