Snowflake
In this doc, we will cover how to setup a Connection to a Snowflake data warehouse.
Prerequisites
- Access credentials
- Snowflake account
- Warehouse and Database name

Figure 1

Figure 2
In Figure 2 above:
- Access Type (required): The type of connection: Read-Only, Write-Only, Read-Write.
- Connection Name (required): The name to identify this connection with, such as 'Snowflake connector'.
- Account (required): Specifies your account identifier. It is common to use the "Account Locator in a Region" which is a format that is a little bit more concise of the form
<account_locator>.<region_id>.<cloud>
, such ascompanyaccount.europe-west4.gcp
. DO NOT add the "snowflakecomputing.com" suffix. - Warehouse (required): Name of the warehouse to use. Each individual read and write connector will be allowed to override which warehouse to use.
- Database Name (required): Name of the default database to use. Each individual read and write connector will be allowed to override which database to use.
- Optional Role Name (optional): A role to use for the connection to Snowflake. If not specified, this will use the default role for the user.
- Choose Credentials (required): Choose from existing credentials or create new credential for connecting to Snowflake if 'Required Credentials' checkbox is selected.

Figure 3
In Figure 3 above, create new credentials if the Required Credentials checkbox was selected and you do not want to use an existing credential.
- Credential Name (required): The name to identify this credential with.
- User (required): Snowflake username to connect with.
- Password (required): Snowflake password to connect with.
Testing and Creating the Connection

Figure 4
In Figure 4 above, use TEST CONNECTION button to check whether credentials are correctly configured and If ALL PASS, click CREATE.
Updated 25 days ago