Property | Description |
Url |
(Required) A string property representing the URL of the Snowflake server that the provider should connect to. Ex. The URL is composed of account name: AA1234, region: eu-west-2.aws(aws) or eu-west-2(azure), and |
Account |
(Optional) A string property representing the name of the Snowflake account that the provider should connect to. |
Database |
(Optional) A string property representing the name of the Snowflake database that the provider should use. If no database is specified, then the default database for API interactions is used. |
Schema |
(Optional) A string property representing the name of the Snowflake schema that the provider should use. If no schema is specified, then the default schema for API interactions is used. |
Warehouse |
(Optional) A string property representing the name of the Snowflake warehouse that the provider should use. If no warehouse is specified, then the default warehouse for API interactions is used. |
Role |
(Optional) A string property representing the name of the Snowflake role that the provider should use. If no role is specified, the current role is used if the user has multiple roles. |
OAuth 2.0 | |
OAuth client secret |
(Required) These fields can be retrieved from the Snowflake console using the query |
OAuth client ID |
(Required) These fields can be retrieved from Snowflake console using the query |
OAuth access token |
(Required) The access token for connecting using OAuth. |
OAuth refresh token |
(Required) The OAuth refresh token for the corresponding OAuth access token. |
OAuth token endpoint |
(Required) The URL is called to get a new access token. |
Key Pair | |
Private key |
(Required)The path of the generated file together with a public key that contains the private key. |
Private key password |
(Optional) The password when the public key is generated. |
Fingerprint |
(Required) The fingerprint of the uploaded public key can be retrieved in the Snowflake console using the query DESC USER username. |
Username |
(Required) The username to login to the console. |