Configure Zenskar's Snowflake connector

🐕‍🦺 Setup guide

This guide will help you configure Zenskar's Snowflake connector. Consequently, you can use Snowflake as a data source in Zenskar.

🚧
Prerequisites
Before configuring Zenskar's Snowflake connector, ensure that you have set up your Snowflake account for integration.

Log into your Zenskar account.
In the left navigation bar, click Metering > Data Sources. In the top-right corner, click + ADD DATA SOURCE.
In the Set Up Source section of the Add New Data Source page, enter a name for the Snowflake data source connection.
Select Snowflake from the Source Type dropdown.

In the Source Config section of the Add New Data Source page, add the following details:

Field	Description
Authorization Method	Select Username and Password from the drop-down menu.
auth_type	The phrase `username/password` will be prepopulated. Do not change.
Username	Enter the username you created.
Password	Enter the password associated with the username.
Host	Enter the host domain of the Snowflake instance (must include the account, region, cloud environment, and end with `snowflakecomputing.com`). For example, `accountname.us-east-2.aws.snowflakecomputing.com`.
Role	Enter the role you created.
Warehouse	Enter the warehouse you created.
Database	Enter the database you created.
Schema	Enter the default schema used as the target schema for all statements issued from the connection that do not explicitly specify a schema name.
JDBC URL Params (Optional)	Enter the additional properties to pass to the JDBC URL string when connecting to the database formatted as `key=value` pairs separated by the symbol `&`. For example, `key1=value1&key2=value2&key3=value3`

If the connector is configured correctly, you will be asked to select the tables to sync:

A table can be expanded to select the columns to sync.

A sync frequency can also be configured.

Finally, click on the FINISH SETUP button to save the connector.