Skip to main content

Adding Snowflake Connection

Adding a New Database​

In the 'Manage Warehouses' section:

  • Click on 'Add New'
  • A form will be presented to you. Fill out the necessary details for the connection:
    • Account Name
    • Warehouse Name
    • User Credentials (only required if SSO is not used)
    • Database Name
    • Role
    • User Credentials: See the user credentials chapter below
  • After entering the details, click on Submit.

User credentials​

Username / password access​

You just need to enter username / password to the corresponding filed. (Set the Auth Type to 'Password')

Snowflake Key Pair Authentication​

If you need to use Snowflake Key Pair (Private key) authentication, you just need to set the auth type to 'Snowflake Private Key'.

The only difference is there's a Private Key field to fill. And there're two scenarios:

  1. Unencrypted Private Key

First you need to generate the private key (and add the corresponding public key to snowflake too), you can refer to this documentation: https://docs.snowflake.com/en/user-guide/key-pair-auth#generate-the-private-key

  1. Encrypted Private Key

When the key is unencrypted (which is not recommended). You can leave the passphrase to empty.

And when the key is encrypted, you need to enter the passphrase when you generate the private key.

Accessing Snowflake Data:​

There are multiple ways to access Snowflake data, such as using username/password, SSO, or Secure Data Sharing.
Details can be found at Snowflake Data Sharing Options.

Additional Instructions: Multi-Database Connections​

  • To enable support for multiple databases, follow the steps in Multi-Database Connections Overview.
  • When multi-db is enabled, you may optionally provide a default database. If you do not provide one, Waii will automatically select a default from the accessible databases.