Snowflake

Warning

Experimental feature: Support for Snowflake is experimental, 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

Limitations and known issues

Datasets

  • When creating the connection, you need to specify one database. Access to tables from other databases is not possible

Importing

  • When importing tables from a Snowflake connection, you’ll see all schemas from all databases. However, you can only import tables from the schemas of the same database as the one defined in the connection

Loading data

  • Loading data in Snowflake by directly INSERTing is extremely slow. Instead, write your data to S3 and use the Snowflake plugin to copy the data to Snowflake in an optimized fashion

Visual recipes

  • Filtering: “contains” operator is not supported
  • Grouping: aggregating on booleans is not supported
  • Window: cumulative average is not supported (Snowflake limitation)

Coding recipes

  • Execution plans are not supported

Charts

  • “Breakdown by day of week” is not supported