medium10 pts · first answer countsdata-warehousingdbtgovernance

Permissions lost after each rebuild

Every time dbt rebuilds a table, the analyst role loses SELECT on it and dashboards fail. What is the cleanest fix in dbt?

A.Ask a DBA to grant access by hand after every runB.Switch the model to ephemeralC.Run dbt only once a monthD.Set the grants config, e.g. grants: {select: ['analyst']}

Discussion 0

Join free to post in the discussion.

Permissions lost after each rebuild

Discussion 0

Related questions