Connecting to Snowflake

Sisense enables easy and quick access to databases, tables and views contained within Snowflake. The steps below describe how to connect to this type of data source.

Note: For the list of connectors available on Linux, click Linux Connectors.

Importing Snowflake Data

To connect to your Snowflake database, you need to provide a connection string that identifies which Snowflake warehouse 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 can 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 import Snowflake data:

  1. In the Data page, open an ElastiCube or click to create a new ElastiCube.
  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. For example:
  5. In User Name, enter your Snowflake user name.
  6. In Password, enter your password.
    Select Use Key Pair Authentication, and enter your Key Pair value.
  7. (Optional) In Additional Parameters, enter additional configuration options by appending key-value pairs to the connection string (e.g., Timeout=60;). For a full list of connection string options, click here.
  8. Click Next. All tables and views associated with Snowflake are displayed.
  9. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, a new option is displayed at the bottom of the list, Add Import Query.
  10. (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.
  11. After you have selected all the relevant tables, click Done. The tables are added to your schema.

Out-of-Memory Issues

When building an ElastiCube with this connector, you might receive an "out of memory" error. To add more memory, see Troubleshooting Out-of-Memory Issues.