Member-only story
Snowflake & DBT
Launching DBT from within Snowflake — Partner Connect:
The necessary objects will be created:
One interesting thing you will see by clicking the Optional Grant at the bottom: “Provide PC_DBT_USER access to tables in an existing database(s) by selecting one or more databases that PC_DBT_ROLE may access. The USAGE privilege will be granted on the selected databases.”. We will do this for on of the databases we have already created:
After creating the objects you will get a pop-up:
Click activate and you will be lead to the DBT registration:
You are provisioned automatically with a 13 day trial hosted on us1.dbt.com: