| 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 snowflakecomputing.com |
| Account |
(Optional) A string property representing the name of the Snowflake account that the provider should connect to. It can be retrieved from the Snowflake console using the query SELECT CURRENT_ACCOUNT(); |
| 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 DESCRIBE INTEGRATION my_oauth_integration; |
| OAuth client ID |
(Required) These fields can be retrieved from Snowflake console using the query DESCRIBE INTEGRATION my_oauth_integration; |
| 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. |
