Snowflake can be used as a data source with SQL-compatible database connector.
Connection String should be a valid connection string for Snowflake .NET driver; for example:
account=test;user=test;password=userpwd;warehouse=wh;db=snowflake_sample_data;host=test.snowflakecomputing.com;
account | Required | Account should not include region or cloud provider information. i.e. account should be XXX instead of XXX.us-east-1. |
---|---|---|
user | Required | This should be the login name for your idp. |
password | Required | The password for the specified user. |
host | Optional | If no value specified, driver will use <ACCOUNT>.snowflakecomputing.com . However, if you are not in us-west deployment, or you want to use global url, HOST is required, i.e. XXX.us-east-1.snowflakecomputing.com , or XXX-jkabfvdjisoa778wqfgeruishafeuw89q.global.snowflakecomputing.com . |
warehouse | Optional | Specifies the default warehouse to use. |
db | Optional | Specifies the default database to use. |
schema | Optional | Specifies the default schema to use. |
role | Optional | Specifies the default role to use. |
To define date-part dimensions (date's "year", "month", "day" etc) you may add dimensions defined with an appropriate SQL expression:
Field
YEAR(date_column)
MONTH(date_column)
+ Format={0:MMM}
(Jan, Feb etc) or {0:MMMM} (January, February etc)
DAY(date_column)
DAYOFWEEKISO(date_column)-1
+ Format={0:ddd}
(Mon, Tue etc) or {0:dddd}
(Monday, Tuesday etc)QUARTER(date_column)
WEEKISO(date_column)