Connecting to Snowflake

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.

   

5. In Connection String, enter your connection string to your Snowflake database. To create a connection string, see JDBC Driver Connection String.

   Example:

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

6. In the User Name field, enter your Snowflake user name.

7. In the Password field, enter your Snowflake password.

   

   Or

   Select Use Key Pair Authentication, and enter:

   • Path to Private Key: Where you stored the Private Key on the Sisense server. For example, if you have created a data folder and copied key.p8 using Admin > App Configuration > File Management, the full path would be /opt/sisense/storage/data/key.p8
     Note: To enable the File Management feature, see Uploading Files to Customize Your Linux Deployment.
   • Private Key passphrase: The password for your Private Key.
   • Account: The unique name of your Snowflake account within your organization. It should correspond to <account_locator>.
   
   

   

   Note:

   Even though you are using the key pair option, you must also provide your user name, as it is a Snowflake requirement.

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.

   

10. (Optional) Click + to customize the data you want to import with SQL. For more information, see Importing Data with Custom Queries.

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 Performance Issues

Connecting Data to a Sisense Live Model

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.

   

   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, see 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.

   Example:

   jdbc:snowflake://<account_name>.snowflakecomputing.com/?warehouse=<warehouse_name>

   snowflake://my-account.snowflakecomputing.com/?warehouse=DEMO_WH

5. In the User Name field, enter your Snowflake user name.

6. In the Password field, enter your Snowflake password.

   

   Or

   Select Use Key Pair Authentication, and enter:

   • Path to Private Key: Where you stored the Private Key on the Sisense server. For example, if you have created a data folder and copied key.p8 using Admin > App Configuration > File Management, the full path would be /opt/sisense/storage/data/key.p8
     Note: To enable the File Management feature, see Uploading Files to Customize Your Linux Deployment.
   • Private Key passphrase: The password for your Private Key.
   • Account: The unique name of your Snowflake account within your organization. It should correspond to <account_locator>.
   
   

   

   Note:

   Even though you are using the key pair option, you must also provide your user name, as it is a Snowflake requirement.

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. (Optional) Database - Enter a database name if you do not want to get a list of databases.

   

   The default Database is an optional property in the connection to a data source. When specified, it acts as a starting point or shortcut, automatically selecting a database during the connection setup to streamline user workflows.

   IMPORTANT:

   The default Database is not a security feature. It does not restrict Sisense users from accessing other databases within the data source. Access should be regulated through user permissions in the Snowflake database management system.

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

    

11. From the Tables list, select the relevant table or view you want to work with.
12. Click Done. The tables are added to your schema.

Note:

When the contents of widgets are sorted in descending order, if they include NULLs, the NULLs are listed first by default. If you want the NULLs to be listed last, use the following command: ALTER ACCOUNT SET DEFAULT_NULL_ORDERING = 'FIRST'; . For more information, see "ORDER BY" in the Snowflake documentation.

Limitations

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