Connection property | Description |
|---|---|
Runtime Environment | The name of the runtime environment where you want to run the tasks. |
Username | The user name to connect to Snowflake account. |
Password | The password to connect to Snowflake 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 user. |
Additional JDBC URL Parameters | The additional connection parameters. You can specify one or more 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 Note: Microsoft ADFS is not supported. For more information about configuring Okta authentication, see the following website: https://docs.snowflake.net/manuals/user-guide/admin-security-fed-auth-configure-snowflake.html#configuring-snowflake-to-use-federated-authentication |
Database/Schema | The Snowflake database and schema name. Specify the parameters in the following format: <database name>/<schema name> Note: You must specify both the database and schema name. If you specify only the database name, source objects do not appear in the Select Source Object window. If you specify only the schema name, an Invalid Schema exception occurs while reading data. |