dbt everywhere- sand, cloud and snowflake
Overview With the Snowflake announcement of supporting dbt core natively in their new workspaces, it seems to have opened the door to easily adopt dbt directly in the cloud and in the data warehouse itself. This makes it easier to onboard new team members and even upskill existing team members to start using dbt directly in snowflake. This article will not go over the details to set up dbt in snowflake, but rather discuss the tradeoffs of using dbt in snowflake, dbt cloud and dbt core in a self-hosted environment. Snowflake also made another announcement with the release of dbt fusion, which is slightly different to dbt core. Lets forgot about fusion for now and carry on with core only discussion. ...