Snowflake connection guide

This guide contains all permissions and requirements for connecting your Snowflake data to Supermetrics.

You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.

After you connect to the data source on the Hub, you can use the data source connection in all available destinations.

Required permissions

The Snowflake data source connector supports OAuth authentication. To connect with OAuth, you need the following:

• Snowflake account with the Account admin role
• OAuth client ID and client secret.
• Account/Server URL
• Full table name
• Warehouse name

Note that these values are case sensitive when connecting to Snowflake connector.

Please also note that the Snowflake table must contain a DATE or DATETIME column to support date range filtering in Supermetrics. You can identify compatible columns by opening the “Columns” tab of your table in Snowflake and sorting by Type.

Step 1: Create an OAuth client ID and client secret

1. Log in to Snowflake and click SYSADMIN.
2. Click Change, and select the ACCOUNTADMIN role. 
3. Run the following 2 commands in a worksheet:
   1. First command:
      CREATE SECURITY INTEGRATION
      "Supermetrics App"
      TYPE = OAUTH
      ENABLED = TRUE'
      OAUTH_CLIENT = CUSTOM
      OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
      OAUTH_REDIRECT_URI = 'https://supermetrics.com/login-complete'
      ;
   2. Second command:
      SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('Supermetrics App');
4. Click row 1 in the output. You'll find this at the bottom of the screen. A popup will open with 3 key-value pairs in JSON format. 
5. Copy the values after the keys OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET. These are your client ID and client secret — keep them safe.

Step 2: Find your Account/Server URL

1. Log in to Snowflake.
2. In the bottom left, click your username.
3. Hover over Account in the menu that appears and click View account details.
4. Copy the value for Account/Server URL.

Step 3: Find your full table name

1. Log in to Snowflake.
2. In the left side navigation, click Data → Databases.
3. Select the database and schema where your table is located.
4. Select the table you want to fetch data from.
5. Once you are at the selected table the database name, schema, and table name are displayed at the top, separated by slashes in this format: DATABASE_NAME / SCHEMA_NAME / TABLE_NAME
6. Copy these names and enter them in the following format when connecting in Supermetrics: DATABASE_NAME.SCHEMA_NAME.TABLE_NAME

Step 4: Find your warehouse name

1. Log in to Snowflake.
2. In the left side navigation, click Data → Databases.
3. Select the database and schema where your table is located.
4. Select the table you want to fetch data from.
5. Open the Data preview tab.
6. The warehouse name is visible next to the number of rows. Copy the warehouse name.

IP allowlisting

To enable Supermetrics for Snowflake, your database needs to accept connections from the Supermetrics IP addresses. See this article for the IP addresses you need to allowlist.

Query types

If prompted, you need to select a query type to pull data.

• Table: Fetch data from your table in Snowflake.

Connection instructions

When connecting to Snowflake, you need to provide your API credentials and set a Date column when prompted. 

1. Select the Snowflake data source on the Supermetrics Hub or in the data destination.
2. If prompted, choose to make this connection shared or private.
3. Click Start.
4. Enter your API credentials, account URL, full table name and click Start.

5. Complete the OAuth login flow.

6. Create a query by selecting the desired metrics and dimensions. 

7. Set a Date column under the options tab. Note that the Date column is case-sensitive and required.

See detailed instructions on how to connect to a data source from the Supermetrics Hub.

You can also connect to Snowflake from these destinations:

• Google Sheets: How to log in to a Supermetrics data source in Google Sheets
• Looker Studio: How to connect data sources to Looker Studio
• Excel: How to connect data sources to Excel with Supermetrics
• Power BI: How to create your first Supermetrics query for Power BI
• The Supermetrics API: How to use the Query Manager

More resources

• How to reauthenticate a data source in Google Sheets, Looker Studio, Excel, or Power BI
• How to reauthenticate a data source in data warehouse, API, or cloud storage platform
• How to manage data source connections on the Supermetrics Hub