CODEWITHSUNDEEP
tableau-apisnowflake-cloud-data-platform
Anshul Agrawal
Anshul Agrawal

Reputation: 21

Tableau connecting to Snowflake using Key-Pair authentication

I'm trying to connect tableau to Snowflake using the Key-pair authentication method. I have generated the keys and associated it with the user. I'm looking for some guidance as how can I configure it on Tableau to use those keys for login to snowflake.

Upvotes: 1

Views: 1478

Answers (3)

Parmjit
Parmjit

Reputation: 1

Snowflake Key Pair Authentication for Tableau - Resolve

Problem tries to solve:

  1. The Snowflake team found the vulnerability connection, so they changed the policy to connect Snowflake as a ‘Key Pair’ authentication.

  2. There is no direct authentication that provides this functionality to make this change in Tableau.

  3. This is an open question/bug on the Snowflake and Tableau community form.

Resolved:

  1. Open the report on is desktop and open the connection as Snowflake.

  2. Snowflake connection puts all the information. do not enter the password and go to the advance tab. (follow the reference link only up to create the connection not everything 😎 )

  3. Create the key pair authentication value and download the key file.

  4. Give the authentication file to the tableau administrator and ask to place the file in the server folder and provide access to the report published user.

  5. In our case we created a service account got permission for access and published the report.

  6. After adding the file and access place the file path.

  7. Sign in without entering a password to the desktop.

  8. Connection is established.

  9. Open the advance tab and add the driver custom setting.

  10. Create the report and publish the report.

  11. Embedded the connection before publishing the report.

  12. Publish the report and run the extract to validate the changes.

Ref: Using Snowflake Key Pair Authentication with Tableau Desktop - Datagami

Upvotes: 0

Roberto B.
Roberto B.

Reputation: 41

It looks like it's possible by specifying additional parameters: Tableau - Snowflake key-pair authentication

Upvotes: 0

Darren Gardner
Darren Gardner

Reputation: 1222

Tableau's Snowflake connector does not currently support key-pair authentication.

Upvotes: 1

Related Questions