The Ultimate Guide to Using dbt With Snowflake
How to setup Your dbt profile with Snowflake database details
If you’re setting up a modern data stack then you know there are certain non-negotiables with the tools you want to use and the functionalities they need to have. For me, Snowflake and dbt are my non-negotiables. They integrate beautifully together to get you the fastest, most efficient data.
No more waiting hours or even days for your data models to run. dbt allows you to organize your models in a way that is modular. I’ve seen my models run over 300 times faster using my local dbt and Snowflake setup compared to other tools like Domo. You just can’t beat it.
How I Use Snowflake and dbt Together
I use Snowflake and dbt together in both my development/testing environment and in production. I have my local dbt code integrated with Snowflake using the profiles.yml file created in a dbt project. This way, I can test a data model locally using the dbt run command and the resultant table will output in my Snowflake development database.
This being said, when using dbt and Snowflake both for testing and production, make sure you have two different databases, one for each environment. I have data_mart_dev in Snowflake for all of my test data…
