Set Up Secure Snowflake Connections in Tableau with Key-Pair Authentication

Prerequisites

Before setting up Snowflake connectivity in Tableau, ensure the following requirements are met:

• Install the latest version of Tableau on your system.

• Install Snowflake ODBC Driver 3.x (or later supported version).

• Verify that the Snowflake ODBC driver is registered as SnowflakeDSIIDriver, which is required for Tableau Snowflake connectivity.

Authenticate and Connect to Snowflake in Tableau Reports

To set up key-pair authentication for Snowflake connections in Tableau Reports, perform the following:

1. Download the Tableau report from Angles Hub and open the downloaded report in Tableau.

2. Drag and drop any column to trigger the authentication prompt. The authentication window appears.

3. Click Edit Connection. The connection dialog is displayed showing the current connection details.

   

   Alternatively, you can edit the connection via the Tableau menu by clicking Data, selecting your report or data source, and clicking Edit Data Source to access the connection settings.

   

4. Click the Authentication dropdown and select Sign In Using Key Pair.

   

5. Click the Private Key File browse button. A file selection window is displayed.

6. Select the required private key file (.p8 or .pem format) and click Open.

7. Enter the private key file password and click Continue.

8. Click Sign In. The report connects successfully once the key-pair authentication details are accepted.