About this integration
This library provides an integration with the Snowflake AI Data Cloud. Connect to Snowflake as a resource, then use the integration-provided functions to construct an op to establish connections and execute Snowflake queries. Read and write natively to Snowflake from Dagster's software-defined assets (SDAs).
Buy Dagster on Snowflake Marketplace

Dagster is now available on Snowflake Marketplace. Teams that already run on Snowflake can buy Dagster through their Snowflake account instead of setting up a separate contract.
- Use your Snowflake commitment. Eligible purchases can draw down your existing Snowflake capacity commitment through Marketplace Capacity Drawdown.
- One bill. Dagster charges appear on your Snowflake invoice, so there is no new vendor to onboard.
- Trusted Snowflake data. Dagster tracks your Snowflake tables and dbt models with their dependencies and run history, checks freshness and quality, and alerts you when a check fails.
View Dagster on Snowflake Marketplace
Installation
pip install dagster-snowflake
Example
# Read the docs on Resources to learn more: https://docs.dagster.io/api/dagster/resources
# This integration also offers an IO manager. Learn more: https://docs.dagster.io/guides/build/io-managers
from dagster import Definitions, EnvVar, asset
from dagster_snowflake import SnowflakeResource
import os
@asset
def my_table(snowflake: SnowflakeResource):
with snowflake.get_connection() as conn:
return conn.cursor().execute_query("SELECT * FROM foo")
defs = Definitions(
assets=[my_table],
resources={
"snowflake": SnowflakeResource(
account="snowflake account",
user="snowflake user",
password=EnvVar("SNOWFLAKE_PASSWORD"),
database="snowflake database",
schema="snowflake schema",
warehouse="snowflake warehouse",
)
}
)
About Snowflake
A cloud-based data storage and analytics service, generally termed "data-as-a-service". Snowflake's data warehouse is one of the most widely adopted cloud warehouses for analytics.
