Introduction
These types of datasources represent the connection to a Snowflake database schema.
Properties
This type of datasource has the following properties:
Key Pair Authentication
The Key Pair authentication option shown below is available in version 3.6.5 and later. We recommended all users upgrade to this as single factor password sign-ins are being deprecated by Snowflake.
Name |
Description |
|---|---|
| Name | The name of this datasource. This does not have to be the name of the database schema in Snowflake. |
| Authentication Type | 'Key Pair' or 'Username / Password' |
| Username | The username to use to connect with. |
| Password | The password to use to connect with. Only available when Authentication Type = 'Username / Password'. |
| Private Key | The private key to use to connect with. Only available when Authentication Type = 'Key Pair'. |
| Private Key Password | The password/passphrase for the private key (optional). Only available when Authentication Type = 'Key Pair'. |
| Account Identifier | The name of the Snowflake account to connect to. |
| Database | The name of the database to connect to in Snowflake . |
| Schema | The name of the database schema to connect to in Snowflake . |
| Warehouse | The name of the data warehouse to use in Snowflake. If not supplied the default will be used for the user. |
| Role | The user role. If not supplied the default will be used for the user. |