Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Connection property
| Description
|
|---|---|
Connection Name
| Name of the connection.
The name is not case sensitive. It must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
|
Description
| Optional. Description that you use to identity the connection.
The description cannot exceed 765 characters.
|
Type
| The Snowflake Data Cloud connection type.
|
Runtime Environment
| The name of the runtime environment where you want to run the tasks.
You cannot run application ingestion tasks and database ingestion tasks on a Hosted Agent or serverless runtime environment.
|
Authentication
| The authentication method that Snowflake Data Cloud Connector must use to log in to Snowflake.
Select
AuthorizationCode .
|
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.
Here,
123abc.us-east-2 is your account name.
For the Snowsight URL, for example,
https://app.snowflake.com/us-east-2.aws/123abc/dashboard , your account name is
123abc.us-east-2 .
Ensure that the account name does not contain underscores. To use an alias name, contact Snowflake Customer Support.
|
Warehouse
| The Snowflake warehouse name.
|
Additional JDBC URL Parameters
| Optional. The additional JDBC connection parameters.
Enter one or more JDBC connection parameters in the following format:
For example:
Ensure that there is no space before and after
= when you add the parameters.
|
Authorization URL
| The Snowflake server endpoint that is used to authorize the user request.
The authorization URL is https://<account_name>.snowflakecomputing.com/oauth/authorize, where <account_name> specifies the full name of your account provided by Snowflake.
For example, https://informatica.snowflakecomputing.com/oauth/authorize
If the account name contains underscores, use the alias name.
|
Access Token URL
| The Snowflake access token endpoint that is used to exchange the authorization code for an access token.
The access token URL is https://<account_name>.snowflakecomputing.com/oauth/token-request, where <account_name> specifies the full name of your account provided by Snowflake.
For example, https://informatica.snowflakecomputing.com/oauth/token-request
If the account name contains underscores, use the alias name.
|
Client ID
| Client ID of your application that Snowflake provides during the registration process.
|
Client Secret
| Client secret of your application.
|
Scope
| Specifies access control if the API endpoint has defined custom scopes.
Enter space separated scope attributes.
For example, specify
session:role:CQA_GCP as the scope to override the value of the default user role. The value must be one of the roles assigned in Security Integration.
|
Access Token Parameters
| Additional parameters to use with the access token URL. Define the parameters in the JSON format.
For example, define the following parameters:
[{"Name":"code_verifier","Value":"5PMddu6Zcg6Tc4sbg"}]
|
Authorization Code Parameters
| Additional parameters to use with the authorization token URL. Define the parameters in the JSON format.
For example, define the following parameters:
[{"Name":"code_challenge","Value":"Ikr-vv52th0UeVRi4"}, {"Name":"code_challenge_method","Value":"S256"}]
|
Access Token
| Populates the access token value.
Enter the access token value or click
Generate Access Token to populate the access token value.
|
Generate
Token
| Generates the access token and refresh token based on the OAuth attributes you specified.
|
Refresh Token
| Populates the refresh token value.
Enter the refresh token value or click
Generate Access Token to populate the refresh token value. If the access token is not valid or expires, the Secure Agent fetches a new access token with the help of refresh token.
If the refresh token expires, provide a valid refresh token or regenerate a new refresh token by clicking
Generate Access Token .
|
