Hello , Dbt version :1.2 We have 3 git branches develop - pointing to GCP dev project uat - pointing to GCP uat project prod - pointing to GCP prod project. If we use the Grant in models/schema.yml file as below , when the models gets executed in dev,uat and prod the required access will grant…

Hello, It work’s , I have defined it as below. {% if target.name == 'dev' %} {{ config(grants = {'roles/bigquery.dataViewer': ['user:someone@yourcompany.com']}) }} {% elif target.name == 'uat' %} {{ config(grants = {'roles/bigquery.dataViewer': ['user:sometwo@yourcompany.com']}) }} {% el…

Using Grants in a target-specific way

Help

system Closed October 11, 2022, 11:17pm 9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Set grants on dataset level in BigQuery Help grants	4	1780	October 4, 2024
Dbt dev/prod data pipelines In-Depth Discussions data-quality , best-practice , environments , adopting-dbt	8	3276	January 16, 2024
Dbt cloud - test free version - limitations Help	1	628	January 8, 2024
[Obsolete] The exact grant statements we use in a dbt project Archive	4	38936	July 10, 2019
Allow user to run jobs in one deployment environment but not in another within the same DBT Cloud project Help	1	1215	November 22, 2023

Using Grants in a target-specific way

Related topics