SeekTable
This documentation page assumes that you already have a SeekTable account. Create your free account by signing up.

Snowflake connection for pivot table reports

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.

Date-part dimensions calculated with SQL expressions

To define date-part dimensions (date's "year", "month", "day" etc) you may add dimensions defined with an appropriate SQL expression:

  1. add new dimension with Type=Field
  2. fill Name with some unique value: say, "date_column_year"
  3. add one Parameter which should be a date-part Snowflake SQL expression:
    • For year: YEAR(date_column)
    • For month: MONTH(date_column) + Format={0:MMM} (Jan, Feb etc) or {0:MMMM} (January, February etc)
    • For day: DAY(date_column)
    • For day-of-week: DAYOFWEEKISO(date_column)-1 + Format={0:ddd} (Mon, Tue etc) or {0:dddd} (Monday, Tuesday etc)
    • For quarter: QUARTER(date_column)
    • For week-of-year: WEEKISO(date_column)