DataConnector | ComponentOne
ADO.NET provider for Snowflake / Connection String Properties
In This Topic
    Connection String Properties
    In This Topic
    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 snowflakecomputing.com

    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 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.