Snowflake + Dagster#

Using Dagster's software-defined assets and Snowflake I/O manager, you can easily interact with Snowflake tables alongside other Dagster assets.

Managing your Snowflake tables with Dagster enables you to:

Use Python to analyze your data stored in Snowflake without writing custom SQL queries to fetch the data
Visualize the data dependencies between tables
Selectively update the contents of your tables
Integrate your Snowflake tables with other tools in your data stack

Snowflake and Dagster tutorial#

In this tutorial, we'll learn how to store and load Dagster's software-defined asset in Snowflake. Click here to get started.

By the end of the tutorial, you will have a connection to your Snowflake instance and a handful of assets that create tables in Snowflake or read existing tables from Snowflake.

References#

Snowflake API reference