Snowflake

How to connect Snowflake to Count.

Click "Connect a database"

Enter your connection details

To enable Count to connect to your Snowflake database, you'll need your full Snowflake account name.

Note that your account name may have additional segments that identify the region and cloud platform that hosts your account.

For example:

xy12345
xy12345.eu-west-1
xy12345.eu-west-2.aws
xy12345.us-central1.gcp
xy12345.switzerland-north.azure

You can see your full account name when logged into Snowflake - it forms the first part of the URL.

For example, if your account name is

xy12345.eu-west-2.aws

then the URL will look like

https://xy12345.eu-west-2.aws.snowflakecomputing.com/...

This account also must be permitted to read the INFORMATION_SCHEMA table within this database.

Connect

Once you hit Connect you will see your connection details including a full list of tables accessible with this connection.

Use Projects to manage which users have access to which tables.

Database access

By default, you are able to query any table in the Snowflake database (limited by the supplied credentials). You are also able to query tables in other databases as long as the credentials have access to those databases, though they do not appear in the Count UI.

If table access is restricted within a Count project, then canvases in that project will be unable to query tables outside of this Snowflake database.

Advanced settings

The Snowflake connection in Count supports a number of advanced settings:

  • Max concurrent connections - Set the maximum number of simultaneous connections between Count and your database. If your database has a lower limit than the value set here, then the lower limit will take precedence.

  • Query timeout - queries executed from Count will be automatically aborted after this length of time.

Troubleshooting

The most common issue when connecting to Snowflake is getting the account name correct. You can find more information about your account name in the Snowflake documentation.

If you have a network policy defined which whitelists connections based on IP address, you may need to allow connections to the following IP addresses for Count to establish a connection:

34.107.75.117
35.198.189.90
35.234.110.177

FAQs

What do I do if we have MFA enabled?

You'll need to create a new user in Snowflake with read-only access that has MFA disabled.

If you are having trouble connecting, reach out to us to schedule a help session

Last updated