Connecting to Snowflake

Prerequisite Software

In order to connect to a Snowflake database, you will need the Snowflake ODBC Driver installed on your PC. This can be downloaded from the Snowflake site https://developers.snowflake.com/odbc/

This is a 64-bit ODBC Driver, so youwill need to use 64-bit AQT.

Configuring the Snowflake ODBC Driver

In order to access your Snowflake database, you will need to configure an ODBC Datasource for your database. The general process for doing this is described in Configuring a Database Connection.

To configure this, specify:

Datasource Name. The name you give this ODBC datasource.
User / Password. Your signon credentials to Snowflake.
Server. Specifies the hostname of your account in the format <account_identifier>.snowflakecomputing.com
We discuss the account identifier later.
Database Name. The name of the database you are to connect to. You must enter a value here. If not, once you sign onto AQT you will get the error:
22000(90105)Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.

It is recommended that you click on Test to ensure that your connection has been configured correctly.

Snowflake2

Account Identifier

To find your account identifier, from the Snowflake panel, go to Accounts and find your account url.

Your account identifier is the account url without the https:// at the start.

The account identifier is entered in the Server field of the ODBC Datasource configuration.

Snowflake1

Advanced Query Tool

https://www.querytool.com