Requirements

  • Snowflake warehouse must be set to AUTO-SUSPEND

Obtain Snowflake connection details

All connection details are case-sensitive. Snowflake stores object names in uppercase unless you wrap the names in double quotes ("") when you create the objects. This includes Warehouse Name, Database Name, and Schema Name.

Connection Detail Detail Description
Account Name The first part of your Snowflake URL: account-name.region.snowflakecomputing.com
Account User The username you use to log in to your Snowflake console.
Database Password The password you use with your Account user to log in to your Snowflake console.
Database Click Databases from within your Snowflake console to view a list of databases.
Warehouse Name Click Warehouses from within your Snowflake console to view a list of warehouses. Any warehouse in your account will work with any database.
Region If not US West Region, your region will be listed in your Snowflake console URL: account-name.region.snowflakecomputing.com
Schema Name Click Databases from within your Snowflake console, then click the name of the database you'd like to use. Switch to the Schemas tab to view a list of schemas for that database. Chartio will automatically default the schema to public in the connection form unless a schema name is entered.

Connect Snowflake to Chartio

From the top navigation bar in Chartio, select Data > +Add Data Source > Snowflake. Enter the connection details obtained in the previous step into the connection form and click Connect.

Note: Remember your Warehouse Name, Database Name, and Schema Name are case-sensitive.

Time zones

Chartio sets Snowflake data sources to UTC. Currently, it’s not possible to override this time zone setting.

Query comment

To provide more context to where queries to your data source are coming from, Chartio includes a query comment to any queries we send; it looks similar to the following:

{
	"reason":"chart_editor",
	"user_email":"support@chartio.com",
	"datasource_id":123456,
	"dashboard_slug":"my-dashboard",
	"chart_id":1234567,
	"datasource_alias":"my data source",
	"organization_id":12345,
	"dataset_id":1231231,
	"is_manual":false,
	"dataset_name":"Dataset 1",
	"dashboard_id":456456
}

Suspended warehouse

Chartio will automatically resume a suspended warehouse prior to schema refresh. Chartio will not resume a suspended warehouse to run a query.