Open navigation

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 the available destinations.

Required permissions

There are 2 ways to authenticate Snowflake: with OAuth, or with a username and password.

To connect with OAuth, you need an account with the Account admin role, plus a client ID and client secret. 

How to 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:
    First command:
    "Supermetrics App"
      TYPE = OAUTH
    Second command:
  4. Click row 1 in the output. You'll find this at the bottom of the screen.
  5. A popup will open with 3 key-value pairs in JSON format. 
  6. Copy the values after the keys OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET. These are your client ID and client secret — keep them safe.

To connect with a username and password, you need a database username and secret key with username, password, hostname, warehouse name, database name, and database schema.

How to find your hostname, database name, and database schema

You can find your hostname in the URL when you're logged in to Snowflake. It should end in

The warehouse name, database name, and database schema can be found in Snowflake at the top right of the query editor.

IP allowlist

To enable Supermetrics for Snowflake, your database needs to accept connections from the following IP addresses:


Query types

You need to select one of the following query types when pulling data:

  • Database table-based report: Select a table from a schema, and use the columns of that table as the fields in Looker Studio.
    • Make sure to check the "Warehouse, database name, and schema are case sensitive" option on the Snowflake login screen to enable this report type to work properly.
    • Date control doesn't work with this report type.
    • If the account you're using has multiple roles and the default role doesn't give it the permissions it needs to retrieve the table list, you might encounter problems getting your full list of tables. Change the account's default role or create a new account with only one role to solve the issue.
  • Database query report: Build an SQL query and use it to create report fields. With the SQL query, combine data from several tables, including those that are in different schemas.
    • Use this SQL workaround to use Date Control with this report type:
      where DATE >= '#start-date#'
      AND DATE <= '#end-date#'

Note that SQL comments and Snowflake functions aren't supported in SQL-based reports.

Connection instructions

When connecting to Snowflake, you need to log in to Snowflake. 

  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. Select an authentication method.
  5. Enter your credentials and click Start.
  6. Create an SQL query under Query SQL.

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

You can also connect to Snowflake from these destinations:

More resources

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.