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 1Figure 1

Figure 1

Figure 2Figure 2

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.
  • 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
  • Choose Credentials (required): Choose from existing credentials or create new credential for connecting to Snowflake if 'Required Credentials' checkbox is selected.
Figure 3Figure 3

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 4Figure 4

Figure 4

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


Did this page help you?