dbt Analytics Engineering Certification

Question

The dbt_project.yml file has the following configuration:

models:  
  +grants:  
    select: ['reporter']

How can you grant both reporter and bi access to the object in the data warehouse?

Explanation

Prefixing the privilege name with + adds bi to the inherited select grantees, retaining reporter. Without the prefix, the model-level grantee list would replace the project-level list. (docs.getdbt.com)

Learn more

dbt grants: Grant config inheritance

dbt Analytics Engineering Certification

AstroTutor

Notes

Readiness

QuestionQ23

Community Discussion