Connect to Snowflake Data Warehouse

You can create a connection to Snowflake Data Warehouse and use the connection to access data for visualization and data-modeling.

Before you start, create a key-pair by following the steps in Set Up Key-Pair Authentication for Snowflake Data Warehouse

See format guidelines, https://docs.snowflake.net/manuals/user-guide/connecting.html.

1. On your home page, click Create, and then click Connection.
2. Click Snowflake Data Warehouse.
3. Enter a Connection Name.
4. In Authentication Type, select Key Pair.
   If you've been using single-factor (basic) authentication, switch to key-pair authentication. Single factor password authentication in Snowflake is desupported from November 2025.
5. In Hostname, enter the host account name using one of the following formats:
   • For Amazon Web Services US West, use <account>.snowflakecomputing.com
   • For all other regions on Amazon Web Services, use <account>.<region>.snowflakecomputing.com
   • For all regions on Microsoft Azure, use <account>.<region>.azure.snowflakecomputing.com

   Where account is the Snowflake account name that you want to use to access the data, for example: exampleaccountname.snowflakecomputing.com.

6. For Database Name, enter the name of the database containing the schema tables and columns that you want to connect to.
7. For Username, enter a user ID with access to the Snowflake data source.
8. In Private API Key, click Select and select the private key that you created when you set up key-pair authentication.
9. For Warehouse, enter the name of the warehouse containing the database, schema tables and columns that you want to connect to. For example, My Snowflake Warehouse.
10. If you want data modelers to be able to use these connection details. click System connection. See Database Connection Options.
11. Click Save.

Set Up Key-Pair Authentication for Snowflake Data Warehouse

You can create a key-pair to authenticate a connection to Snowflake Data Warehouse.

1. Open a local terminal window.
2. Create a private key using this command:
   openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt
3. Create a public key using this command:
   openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub
4. Log into your Snowflake account and create a SQL worksheet.
5. Assign the public key to a Snowflake user.
   ALTER USER <user> SET RSA_PUBLIC_KEY = <public key>;
6. Verify the assigned public key of the Snowflake user using this command:
   DESCRIBE USER <user>;