This page describes the credentials you need to enter on the Connection credentials screen to create a Snowflake connection. The credentials change based on the type of authentication.

There are two types of authentication methods: Key Pair Authentication and Username/Password.

Authenticate with a key pair

If you select Key Pair Authentication as the Auth Type option, complete these fields:

Connection credentials fieldsDescription
Auth TypeSelect Key Pair Authentication.
Username

The user name required to authenticate. Must be a string with a maximum length of 255 characters. 

Example: ANAPLAN_USER

Private Key

The private key required to authenticate. Must be a string with a maximum length of 1800 characters.

To generate the private key, see the Snowflake documentation .

The private key must be provided in an unencrypted PEM format. Data Orchestrator requires direct access to the raw key material to establish a secure connection with systems like Snowflake.

Example:

-----BEGIN PRIVATE KEY-----
MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDxq...
... (Your private key content in Base64) ...
... multiple lines ...
-----END PRIVATE KEY-----

Host

The host domain of the Snowflake instance. It must include the account, region, cloud environment, and end with snowflakecomputing.com. You can get the host name from the browser URL when you are logged in to Snowflake. You can also get the full host URL from ‌the activation email. 

Example: accountname.us-east-2.aws.snowflakecomputing.com

Role

The role created for Data Orchestrator to access Snowflake. It must be a string with a maximum length of 255 characters. 

Example: ADO_ROLE

Warehouse

The warehouse created for Data Orchestrator to synchronize data into. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters. 

Example: PLANNING_WAREHOUSE

Database

The database created for Data Orchestrator to synchronize data into. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters. 

Example: PLANNING_DATABASE

SchemaThe schema whose tables this replication is targeting. If no schema is specified, all tables with permissions will be presented regardless of their schema. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters.

Authenticate with a user name and password

If you select Username/Password as the Auth Type option, complete these fields:

Connection credentials fieldsDescription
Auth TypeSelect Username/Password.
Username

The user name required to authenticate. Must be a string with a maximum length of 255 characters. 

Example: ANAPLAN_USER

PasswordThe password required to authenticate. It must be a string with a maximum length of 255 characters. This field is hidden for security reasons.
Host

The host domain of the Snowflake instance. It must include the account, region, cloud environment, and end with snowflakecomputing.com. You can get the host name from the browser URL when you are logged in to Snowflake. You can also get the full host URL from ‌the activation email. 

Example: accountname.us-east-2.aws.snowflakecomputing.com

Role

The role created for Data Orchestrator to access Snowflake. It must be a string with a maximum length of 255 characters. 

Example: ADO_ROLE

Warehouse

The warehouse created for Data Orchestrator to synchronize data into. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters. 

Example: PLANNING_WAREHOUSE

Database

The database created for Data Orchestrator to synchronize data into. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters. 

Example: PLANNING_DATABASE

SchemaThe schema whose tables this replication is targeting. If no schema is specified, all tables with permissions will be presented regardless of their schema. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters.