# \#grants

**URL:** https://discourse.getdbt.com/tag/grants/42.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [Set grants on dataset level in BigQuery](https://discourse.getdbt.com/t/set-grants-on-dataset-level-in-bigquery/5073)

<div class="topic-metadata">

**Author:** [@chricko](https://discourse.getdbt.com/u/chricko)\
**Replies:** 4\
**Last updated:** [October 4, 2024, 10:41am UTC](https://discourse.getdbt.com/t/set-grants-on-dataset-level-in-bigquery/5073 "2024-10-04T10:41:21Z")

</div>

Hi, i am trying to set specific viewer-access in BigQuery on a dataset through dbt and dbt\_project.yml file. a\_folder\_in\_models: +dataset: some\_dataset +grants: roles/bigquery.dataViewer: \['group:group@company.…

---

## [How to grant privilege to Groups using Grant (redshift)](https://discourse.getdbt.com/t/how-to-grant-privilege-to-groups-using-grant-redshift/7507)

<div class="topic-metadata">

**Author:** [@divrodt](https://discourse.getdbt.com/u/divrodt)\
**Replies:** 2\
**Last updated:** [July 20, 2023, 1:33am UTC](https://discourse.getdbt.com/t/how-to-grant-privilege-to-groups-using-grant-redshift/7507 "2023-07-20T01:33:33Z")

</div>

Hi, I’m reading through this link: grants | dbt Developer Hub (getdbt.com) And I cannot find a way to define if you’re granting privilege to a GROUP. Would be cool if we don’t need to do macros for this and just use th…

---

## [Snowflake config grants - privileges did not get granted to the role](https://discourse.getdbt.com/t/snowflake-config-grants-privileges-did-not-get-granted-to-the-role/7773)

<div class="topic-metadata">

**Author:** [@yijentu](https://discourse.getdbt.com/u/yijentu)\
**Replies:** 0\
**Last updated:** [April 11, 2023, 12:54pm UTC](https://discourse.getdbt.com/t/snowflake-config-grants-privileges-did-not-get-granted-to-the-role/7773 "2023-04-11T12:54:23Z")

</div>

I’ve added this {{ config(grants = {‘+select’: \[‘reporter\_finance’\]}) }} to the top of my data model in dbt (according to grants | dbt Developer Hub). The data model was built without error message. The view was populate…

---

## [incremental models not visible to snowflake roles after build](https://discourse.getdbt.com/t/incremental-models-not-visible-to-snowflake-roles-after-build/6253)

<div class="topic-metadata">

**Author:** [@wdunlap](https://discourse.getdbt.com/u/wdunlap)\
**Replies:** 2\
**Last updated:** [January 20, 2023, 6:42pm UTC](https://discourse.getdbt.com/t/incremental-models-not-visible-to-snowflake-roles-after-build/6253 "2023-01-20T18:42:06Z")

</div>

i have an issue with my snowflake roles permissions related to my incremental models…when I run dbt build -s \<incremental\_model\> , snowflake roles with select permissions on the table suddenly lose visibility to the tabl…

---

## [Grant & revoke in Big query](https://discourse.getdbt.com/t/grant-revoke-in-big-query/5057)

<div class="topic-metadata">

**Author:** [@minhajpasha](https://discourse.getdbt.com/u/minhajpasha)\
**Replies:** 3\
**Last updated:** [January 11, 2023, 7:58pm UTC](https://discourse.getdbt.com/t/grant-revoke-in-big-query/5057 "2023-01-11T19:58:03Z")

</div>

Hello @joellabes dbt core:1.2 dwh: Bigquery Model type: Incremental The access is not getting revoked via DBT.Below are the steps which i have followed and could see issue in the dbt. case one: I have applied the g…

---

## [Run dbt between separate snowflake databases in the same account](https://discourse.getdbt.com/t/run-dbt-between-separate-snowflake-databases-in-the-same-account/4935)

<div class="topic-metadata">

**Author:** [@Vince](https://discourse.getdbt.com/u/Vince)\
**Replies:** 2\
**Last updated:** [September 21, 2022, 11:32am UTC](https://discourse.getdbt.com/t/run-dbt-between-separate-snowflake-databases-in-the-same-account/4935 "2022-09-21T11:32:21Z")

</div>

I have a snowflake account with my raw data in database RAW, and a separate database ANALYTICS where I would like to store the output of transformation models done by dbt, e.g. run model abc.sql “select 1 from RAW.schem…