Snowflake Data Source
Snowflake is a fully managed, cloud-based OLAP database optimized for large-scale analytics and batch processing. It features independent scaling of storage and compute, automatic data partitioning, and high-performance parallel query execution.
To configure a connection to Snowflake, select Snowflake as the data source type. Dedicated Snowflake fields will appear—complete these fields as described below:
Snowflake data source definition properties
| Field | Description |
|---|---|
| Data Source Description | Enter a unique name. Example: Snowflake Data Source |
| Type | Select Snowflake. |
| Server | Enter a Snowflake account name. |
| Database Name | Enter the warehouse or database name. |
| Extra connection string properties | Enter any additional connection string parameters required by the database provider. |
| Database Schema Name | Enter the shema name only (do not include database prefix). |
| Authentication Strategy | Select the method for authenticating with Snowflake. For Key-Pair Authentication, use your public and private keys if supported. |
| Key User | Enter the username for authenticating with Snowflake. |
| Private Key | Upload the private key file for authentication. |
| Pass Phrase | (Optional) Enter the password if the private key file is protected. |
| User Name | Enter the username for database authentication. |
| Password | Enter the password for the specified user. |