Connecting to Snowflake
  • 28 Sep 2022
  • 3 Minutes to read
  • Dark
    Light

Connecting to Snowflake

  • Dark
    Light

Note:

This topic describes how to import data into Sisense's ElastiCube, and how to use Live Connect.

Sisense enables easy and quick access to databases, tables and views contained within Snowflake.

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.

Store your Key Pair here: /opt/sisense/storage/<any sub-folder>

You can import your data into a Sisense ElastiCube , or connect your data to a Sisense Live model, using Live Connect .

Importing Into a Sisense ElastiCube

Importing Into a Sisense ElastiCube

To import Snowflake data:

  1. In the Data page, open an ElastiCube or click  to create a new ElastiCube.
  2. 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.
  3. In the Model Editor, click  the Add Data dialog box is displayed.
  4. In the Add Data dialog box, select Snowflake.
    8-5snowflakethumb0300.png
  5. In Connection String, enter your connection string to your Snowflake database. To create a connection string, see JDBC Driver Connection String.
    For example:
    jdbc:snowflake://<account_name>.snowflakecomputing.com/?warehouse=<warehouse_name>
    snowflake://my-account.snowflakecomputing.com/?warehouse=DEMO_WH
  6. Enter your Snowflake user name in the User Name field.
  7. Enter your Snowflake password in the Password field.
8-5snowflake-connection-string.png
OR
Select Use Key Pair Authentication, and enter:
  • Path to Private Key: Where you stored the Private Key on your computer.
  • Private Key passphrase: The password for your Private Key.
  • Account: The unique name of your Snowflake account within your organization.

8. (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 .

9. Click Next . All tables and views associated with Snowflake are displayed.

8-5snowflake-previewthumb0300.png
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 Memory Issues

Connecting Data to a Sisense Live Model

Connecting Data to a Sisense Live Model

  1. In the Data page, open a live model or click 8-5livebutton1.png to create a new live model.
  2. In the Model Editor, click8-5databutton4.png the Add Data dialog box is displayed.
  3. In the Add Data dialog box, select Snowflake.

8-5snowflakethumb03001.png

Note:

User parameters (which are defined in the User Parameters area of the Sisense Admin console) may be used for these Snowflake connection settings:

  • Connection string - Using full JDBC string, Snowflake domain, warehouse and database
  • User name
  • Password
  • Dynamic Schema

For more information about user parameters and the Dynamic Schema functionality, please refer to Managing Live Dynamic Connections.

4. In Connection String, enter your connection string to your Snowflake database. To create a connection string, see JDBC Driver Connection String. For example:

jdbc:snowflake://<account_name>.snowflakecomputing.com/?warehouse=<warehouse_name>
snowflake://my-account.snowflakecomputing.com/?warehouse=DEMO_WH

5. Enter your Snowflake user name in the User Name field.
6. Enter your Snowflake password in the Password field.

OR

Select Use Key Pair Authentication, and enter:

  • Path to Private Key: Where you stored the Private Key on your computer.
  • Private Key passphrase: The password for your Private Key.
  • Account: The unique name of your Snowflake account within your organization.

7. (Optional) Use the Dynamic Schema option to automatically select the schema defined for your user in the User Parameters area of the Sisense Admin console.



8. (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.
9. Click Next. All tables and views associated with Snowflake are displayed.


8-5snowflake-previewthumb03001.png
10. From the Tables list, select the relevant table or view you want to work with.
11. Click Done. The tables are added to your schema.

Limitations

  • The timestamp_ltz data type is not supported. Use timestamp_tz instead.

Was this article helpful?