Connecting to Snowflake

This topic describes how you can add live connections to your Snowflake databases in Sisense.

For information about live connections, see Sisense Live Connect.

To connect to your Snowflake database, you need to provide a connection string that identifies which Snowflake database you are connecting to and that database’s credentials. To create a connection string, see JDBC Driver Connection String.

Note: You must provide the warehouse name (warehouse=<name>) and database name (db=<name>) in the connection string.

Alternatively, you provide your connection string and instead of user credentials, you can use Key-Pair credentials for authentication. For more information, see Using Key Pair Authentication.

To add a Snowflake live connection:

  1. In the Data page, open a live model or click to create a new live model.
  2. In the Model Editor, click . The Add Data dialog box is displayed.
  3. In the Add Data dialog box, select Snowflake.

  4. In Connection String, enter your connection string to your Snowflake database. To create a connection string, see JDBC Driver Connection String.
  5. In User Name, enter your Snowflake user name.
  6. In Password, enter your password.
    OR
    Select Use Key Pair Authentication, and enter your Key Pair value.
  7. Click Next. All tables and views associated with Snowflake are displayed.
  8. From the Tables list, select the relevant table or view you want to work with.
  9. After you have selected all the relevant tables, click Done. The tables are added to your schema.

Limitations