Your user will need to be able to:
selectfrom raw data in your warehouse (i.e. data to be transformed)
createschemas, and therefore create tables/views within that schema¹
- read system views to generate documentation (i.e. views in
On Postgres, Redshift, and Snowflake, use a series of
grants to ensure that
your user has the correct privileges.
On BigQuery, use the "BigQuery User" role to assign these privileges.
¹Alternatively, a separate user can create a schema for the dbt user, and then grant the user privileges to create within this schema. We generally recommend granting your dbt user the ability to create schemas, as it is less complicated to implement.