dbt and Snowflake

Data Transformation for Snowflake Data Cloud

Build, test and deploy data transformation pipelines using dbt and the Snowflake Data Platform.

“The new workflow with dbt and Snowflake isn’t a small improvement. It’s a complete redesign of our entire approach to data that will establish a new strategic foundation for analysts at JetBlue to build on.”

Ben Singleton, Director of Data Science & Analytics at JetBlue

Trusted by the world's leading data teams

Why dbt + Snowflake?

Silos erode data team effectiveness, and ultimately, data trust. dbt works on top of Snowflake to provide a centralized environment for collaborative data transformation. Now anyone on your data team who knows SQL can collaborate on end-to-end transformation workflows in Snowflake.

[New!] dbt Cloud is now on Snowflake Partner Connect! Get up and running with a free trial almost instantly through the Snowflake interface.

Hit the ground running

dbt and Snowflake operate in the universal language of data teams: SQL. No new skills are required, and experience is transferable.

Scale up or down with ease

Apply logic in dbt to select the right Snowflake warehouse size for each dbt model, allowing you to control run-time, manage costs, and meet internal data freshness SLAs.

Work in multiple environments

Easily maintain separate production and development environments with fine-grained permissions, mitigating the impact of errors and reducing data downtime.

Practice better data access control

Apply and version control rules to make use of Snowflake’s dynamic data masking from within your dbt workflow, allowing you to control access to PII or other sensitive data.

Take the hassle out of administration

Execute and version control administrative tasks related to your dbt projects using dbt hooks and operations macros.

The Analytics Engineering Workflow

With dbt, data teams work directly within the warehouse to produce trusted datasets for reporting, ML modeling, and operational workflows.

“With Snowflake and dbt, the people who have the business problem now have the tools to go and solve their business problem.”

Ryan Goltz, Principal Data Architect, Fortune 500 Oil & Gas Company

Get Started Today

Get started

Start a dbt Cloud free trial

Get started

Read

Blog post: How we configure Snowflake

Check it out

Discuss

Join the conversation on dbt Slack

Explore the Snowflake channel

[Upcoming Event] Snowflake Build Summit 2021

October 4-5, 2021: Don't miss our Virtual Hands on Lab: Accelerating Data Teams with Snowflake & dbt

Sign Up