Connect to your data in your Snowflake data warehouse
Snowflakeis a cloud data warehouse with a SQL interface. Snowflake stores both structured and semi-structured data, including JSON and XML. You can connect to your Snowflake data using Snowflake's user authentication.Snowflake connector properties
Here are the properties for the Snowflake connector:
| Property | Description |
|---|---|
| Data Source Name | Enter the name of the data source |
| Username | Enter the username of the Snowflake account used to authenticate to the server |
| Password | Enter the password of the Snowflake account used to authenticate to the server |
| Connection Pool | Enter the connection pool. The default is 30. |
| Connection String | Enter the connection string for the Snowflake JDBC driver. The format is: jdbc:snowflake://<HOST>:<PORT>/<DATABASE_NAME>. The <HOST> is <ACCOUNT_NAME>.<REGION>.snowflakecomputing.com, where <ACCOUNT_NAME> specifies the full name of your account provided by Snowflake and <REGION> specifies the region for your account. The <PORT> default is 443 for HTTPS. |
| Set Extraction Timeout? | Enable this property to terminate the extraction job for a SQL query after a specified time. |
| Stop After (Minutes) | Enable Set Extraction Timeout? to configure this property. Enter the maximum number of minutes that the extraction job for a SQL query can run before the system automatically terminates it. |
| Connection Properties | Optionally enter connector properties for a custom connection to Snowflake in the format:propertyName=propertyValueEach connector property is on a new line. Refer to the Connection Parameters section of the Snowflake JDBC Driver documentation for further information. |
Additional considerations
Note that your full account name might include additional segments that identify the region and a cloud platform.
Learn more about how to configure the Snowflake connector.