Snowflake

Note

Support for Snowflake is provided as a Beta version, with a best-effort support.

Note

We have a detailed howto for your first steps with SQL databases in DSS.

You might want to start with that Howto. The rest of this page is reference information for Snowflake

DSS supports the full range of features on Snowflake:

  • Reading and writing datasets
  • Executing SQL recipes
  • Performing visual recipes in-database
  • Using live engine for charts

Installing the JDBC driver

The Snowflake JDBC driver can be downloaded from Snowflake website (https://docs.snowflake.net/manuals/user-guide/jdbc.html)

The driver is made of a single JAR file snowflake-jdbc-VERSION.jar

To install:

  • Copy this JAR file to the lib/jdbc driver of DSS
  • Restart DSS

Creating a Snowflake connection

As a beta-support database, there is not a dedicated “Snowflake” connection in DSS.

Instead, create a “Other databases (JDBC)” connection, and enter the following information:

  • JDBC Driver class: net.snowflake.client.jdbc.SnowflakeDriver
  • JDBC URL: jdbc:snowflake://YOUR_IDENTIFIER.snowflakecomputing.com?user=YOUR_USER&password=YOUR_PASSWORD&db=YOUR_DB&warehouse=YOUR_WAREHOUSE&schema=public&role=YOUR_ROLE
  • SQL dialect: Snowflake

Creating Snowflake datasets

To create a Snowflake dataset, you need to create a “Other SQL databases” dataset. You can also Import your tables.