Snowflake
Authentication
To set up a Snowflake data source you will need your username, password, account identifier and a default warehouse.
Make sure the account you are using has permission to access the tables you wish to query.
We use the new format of account identifier as described in the Snowflake documentation here.
Do not use your account name, which has the format <account>.<region>.<platform>.
It should have the format <org_name>-<account_name>. You can find it on the Snowflake dashboard here:
Snowflake has the option of implementing a Network Policy in order to restrict access based on IP addresses.
If you are not using a Network Policy, then your database is publicly accessible.
If you have enabled a Network Policy, then you will need to enable Causal to connect to your database by white listing ALL the static IP addresses listed below.
- 146.148.57.218
- 35.184.187.183
- 35.224.101.145
Configuration
To configure your Snowflake data source you will need to specify the query, the date column, and any variable columns. The date column should be one of Snowflakes's date formats and variable columns should be numeric.
Any columns that aren't a date or variable column will be considered a category, and should have a string type. An exception is the 'cohort' category, which should be a date, with the column header explicitly labelled Cohort.
For more details about how to write queries for Causal data sources check out Table Format.