Configure Tableau for Snowflake Key-pair Authentication
To publish workbooks or flows using Snowflake data sources protected with Key-pair authentication from Tableau Desktop or Tableau Prep to a Tableau Cloud or Tableau Server site, you must also configure that site to support those credentials. This involves adding your new or updated authentication details for Snowflake Key-pair authentication to the Saved Credentials section of your Account Settings.
Notes
-
To support using Key-pair authentication to connect to Snowflake, you must install an ODBC driver from Snowflake that is version 3.4.0 or newer.
-
You need to use OpenSSL version 3.x or newer to create the keys for this authentication.
-
Each instance of Tableau Desktop that uses Snowflake data protected by Key-pair authentication will require the user to provide the key file as part of connecting to data. For more information, see Snowflake.
-
Workbooks, data sources, and Prep flows that contain key-pair authentication must be published to Tableau Cloud or Tableau Server from Tableau Desktop or Tableau Prep Builder.
-
Key-pair authentication is currently unsupported for the following:
-
Workbook or data source web authoring, including editing existing published workbooks or data sources on the web
-
Prep web authoring, including editing existing Prep flows on the web
-
Virtual Connections (VConns)
-
Add Key-pair Authentication Details
-
Sign in to Tableau Cloud or Tableau Server and navigate to your My Account Settings page.
-
Locate Saved Credentials for Data Sources in the Security section.
-
Next to Snowflake, click Add.
-
In the Add a New Saved Credential window, select Key-pair Authentication, and then click Add.
-
In the Add Key-pair Authentication Credential window, enter your Snowflake server, Role (optional), and Username associated with these credentials.
Note: Role and Username are case sensitive and must match what is saved on Tableau Cloud or Tableau Server under My Account Settings > Snowflake key pair information.
-
For Private Key File, click Choose a file and select the .p8 file that contains your private key.
-
(Optional) If the key has a password or passphrase associated with it, enter it in the Password field, and then click Add.
You are now ready to share workbooks and flows protected by Key-pair authentication from Tableau Desktop or Tableau Prep Builder to your site.
See also
-
Snowflake - Learn how to set up a connection to Snowflake to retrieve and analyze data.
