[Solved] You wrote this access control in your dbt_project.yml: access_control: - role: analyst models: - sales - customers - role: viewer models:... | dbt

dbt - Governance and Collaboration

You wrote this access control in your dbt_project.yml:

access_control:
  - role: analyst
    models:
      - sales
      - customers
  - role: viewer
    models:
      - sales

But analysts report they cannot see the customers model. What is the likely error?

AThe <code>access_control</code> block is not supported in <code>dbt_project.yml</code>

BThe role name 'analyst' is misspelled

CThe models list must be under each model, not role

DThe <code>customers</code> model does not exist in the project

Step-by-Step Solution

Solution:

Step 1: Check where access controls are defined in dbt
dbt does not support an access_control block in dbt_project.yml. Access controls are managed outside or via external tools.
Step 2: Analyze other options
Role spelling or model existence might cause issues, but the main problem is unsupported syntax in the config file.
Final Answer:
The access_control block is not supported in dbt_project.yml -> Option A
Quick Check:
Access control block unsupported = The access_control block is not supported in dbt_project.yml [OK]

Quick Trick: Access controls not set in dbt_project.yml [OK]

Common Mistakes:

MISTAKES

Master "Governance and Collaboration" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

You wrote this access control in your dbt_project.yml: