Table of Contents

Search

  1. Preface
  2. Introducing Mass Ingestion
  3. Getting Started
  4. Connectors and Connections
  5. Mass Ingestion Databases
  6. Mass Ingestion Streaming
  7. Monitoring Ingestion Jobs
  8. Asset Management
  9. Troubleshooting

Mass Ingestion

Mass Ingestion

Snowflake Cloud Data Warehouse V2 connection properties

Snowflake Cloud Data Warehouse V2 connection properties

When you set up a Snowflake Cloud Data Warehouse V2 connection, you must configure the connection properties.
The following table describes the Snowflake Cloud Data Warehouse V2 connection properties:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
Snowflake Cloud Data Warehouse V2 also supports the Hosted Agent.
Authentication
Select the authentication method that the connector must use to log in to Snowflake.
Select
Standard
. Default is
Standard
.
Username
The user name to connect to the Snowflake Cloud Data Warehouse account.
Password
The password to connect to the Snowflake Cloud Data Warehouse account.
Account
The name of the Snowflake account.
In the Snowflake URL, your account name is the first segment in the domain.
For example,
123abc
is your account name in
https://123abc.snowflakecomputing.com
.
Warehouse
The Snowflake warehouse name. You must specify the warehouse name.
Role
The Snowflake role assigned to the user.
Additional JDBC URL Parameters
Optional. The additional JDBC connection parameters.
Enter one or more JDBC connection parameters in the following format:
<param1>=<value>&<param2>=<value>&<param3>=<value>....
For example:
user=jon&warehouse=mywh&db=mydb&schema=public
To override the database and schema name used to create temporary tables in Snowflake, enter the database and schema name in the following format:
ProcessConnDB=<DB name>&ProcessConnSchema=<schema_name>
To access Snowflake through Okta SSO authentication, enter the web-based IdP implementing SAML 2.0 protocol in the following format:
authenticator=https://<Your_Okta_Account_Name>.okta.com
Microsoft ADFS is not supported.


Updated June 15, 2020