> ## Documentation Index
> Fetch the complete documentation index at: https://zenskar.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Configure Zenskar's Snowflake connector

> This guide provides step-by-step instructions for configuring Zenskar's Snowflake connector, including setting up the data source, configuring connection details, selecting tables and columns to sync, and setting sync frequency.

## 🐕🦺 Setup guide

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

<Warning>
  ### Prerequisites

  Before configuring Zenskar's Snowflake connector, ensure that you have [set up your Snowflake account for integration](/docs/20240301/third-party-integrations/data-sources/snowflake/set-up-snowflake).
</Warning>

### ⚙️ Set up data source and type

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

### ⚙️ Configure data source

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](/docs/20240301/third-party-integrations/data-sources/snowflake/set-up-snowflake#create-a-user-for-zenskar).                                                                        |
| Password                                                                                              | Enter the password associated with the username.                                                                                                                                                               |
| [Host](https://docs.snowflake.com/en/user-guide/admin-account-identifier.html)                        | 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](https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#roles)          | [Enter the role you created](/docs/20240301/third-party-integrations/data-sources/snowflake/set-up-snowflake#create-a-role-for-zenskar).                                                                            |
| [Warehouse](https://docs.snowflake.com/en/user-guide/warehouses-overview.html#overview-of-warehouses) | [Enter the warehouse you created](/docs/20240301/third-party-integrations/data-sources/snowflake/set-up-snowflake#create-a-warehouse-and-a-database-for-zenskar).                                                   |
| [Database](https://docs.snowflake.com/en/sql-reference/ddl-database.html#database-schema-share-ddl)   | [Enter the database you created](/docs/20240301/third-party-integrations/data-sources/snowflake/set-up-snowflake#create-a-warehouse-and-a-database-for-zenskar).                                                    |
| [Schema](https://docs.snowflake.com/en/sql-reference/ddl-database.html#database-schema-share-ddl)     | 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](https://docs.snowflake.com/en/user-guide/jdbc-parameters.html) (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`  |

### Select tables and columns to sync

#### Select tables to sync

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

#### Select columns to sync

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

* A [cursor](https://en.wikipedia.org/wiki/Cursor_\(databases\)) can be set against a column.
* A column can be set as the [primary key](https://en.wikipedia.org/wiki/Primary_key).

#### Select sync frequency

A sync frequency can also be configured.

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

***