Administrator
- Administrator
- All Products
Property
| Description
|
---|---|
Account
| The name of the Snowflake account.
For example, if the Snowflake URL is https://<123abc>.us-east-2.aws.snowflakecomputing.com/console/login#/, your account name is the first segment in the URL before snowflakecomputing.com. Here, 123abc.us-east-2.aws is your account name.
If you use the Snowsight URL, for example, https://app.snowflake.com/us-east-2.aws/<123abc>/dashboard, your account name is 123abc.us-east-2.aws.
Ensure that the account name doesn't contain underscores. If the account name contains underscores, you need to use the alias name. To use an alias name, contact Snowflake Customer Support.
|
Warehouse
| The Snowflake warehouse name.
|
Access Token URL
| The Snowflake access token endpoint that is used to exchange the authorization code for an access token.
Specify the access token URL that you get from the OAuth endpoint.
|
Client ID
| Client ID of your application generated when you configure the application for OAuth.
|
Client Secret
| Client secret generated for the client ID.
|
Scope
| Determines the access control when the API endpoint has defined custom scopes.
For example, specify
session:role:CQA_GCP as the scope to override the value of the default user role. The value needs to one of the roles assigned in Security Integration.
To enter multiple scope attributes, separate each scope attribute with a space.
|
Access Token
| The access token value.
Enter the populated access token value that you get from the OAuth endpoint, or click
Generate Access Token to populate the access token value.
|
Property
| Description
|
---|---|
Additional JDBC URL Parameters
| The additional JDBC connection parameters.
You can specify multiple JDBC connection parameters, separated by ampersand (&), in the following format::
For example, you can pass the following database and schema values when you connect to Snowflake:
When you add parameters, ensure that there is no space before and after the equal sign (=).
|
Access Token Parameters
| Additional parameters to use with the access token URL.
Define the access token parameters in the following JSON format:
[{"Name":"<Parameter name>","Value":"<Parameter value>"}]
For example, you can use the following code_verifier parameter when you connect to Snowflake:
[{"Name":"code_verifier","Value":"5PMddu6Zcg6Tc4sbg"}]
For more information about access token parameters that you can define, see
Introduction to OAuth in the Snowflake documentation.
|