# Set schema/dataset for BigQuery

**URL:** <https://discourse.getdbt.com/t/set-schema-dataset-for-bigquery/13995>\
**Category:** Help\
**Tags:** bigquery, dbt-cloud\
**Created:** [June 30, 2024, 6:48pm UTC](https://discourse.getdbt.com/t/set-schema-dataset-for-bigquery/13995 "2024-06-30T18:48:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![martin\_larsson](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/martin_larsson/32/1971_2.png) [@martin\_larsson](https://discourse.getdbt.com/u/martin_larsson)\
**Post date:** [June 30, 2024, 6:48pm UTC](https://discourse.getdbt.com/t/set-schema-dataset-for-bigquery/13995/1 "2024-06-30T18:48:07Z")

</div>

## The problem I’m having

The schema that I have set in dbt\_project.yml does not take effect in my production environment when using dbt cloud.

## The context of why I’m trying to do this

Im running a project in dbt cloud and using Google BigQuery. I just tried to add a specified schema in the dbt\_project.yml and when Im developing and building I get the corresponding schemas as datasets in BigQuery. But when I merge in to master and the CI build runs it does not create the corresponding datasets.

## What I’ve already tried

## Some example code or error messages

Here are the relevant config from dbt\_project.yml:

```yaml
models:
  provet_hammaro:
    +materialized: view
    +database: provet-hammaro

    staging:
      +schema: staging
      +materialized: view

    marts:
      +schema: marts
      +materialized: table 

```

In BiQuery I have the following datasets:

- dbt\_mlarsson
- dbt\_mlarsson\_staging
- dbt\_mlarsson\_marts
- provet\_hammaro

I expected to have these datasets as well:

- provet\_hammaro\_staging
- provet\_hammaro\_marts

---

<div class="post-metadata">

**Author:** ![martin\_larsson](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/martin_larsson/32/1971_2.png) [@martin\_larsson](https://discourse.getdbt.com/u/martin_larsson)\
**Post date:** [July 5, 2024, 6:50pm UTC](https://discourse.getdbt.com/t/set-schema-dataset-for-bigquery/13995/2 "2024-07-05T18:50:05Z")

</div>

Has anyone seen this?

---

<div class="post-metadata">

**Author:** ![martin\_larsson](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/martin_larsson/32/1971_2.png) [@martin\_larsson](https://discourse.getdbt.com/u/martin_larsson)\
**Post date:** [July 10, 2024, 10:39am UTC](https://discourse.getdbt.com/t/set-schema-dataset-for-bigquery/13995/3 "2024-07-10T10:39:19Z")

</div>

Is everybody on vacation or am I not being clear enough? Is there a guide or examples on how schemas work when running in BigQuery?

---

<div class="post-metadata">

**Author:** ![martin\_larsson](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/martin_larsson/32/1971_2.png) [@martin\_larsson](https://discourse.getdbt.com/u/martin_larsson)\
**Post date:** [August 4, 2024, 6:25pm UTC](https://discourse.getdbt.com/t/set-schema-dataset-for-bigquery/13995/4 "2024-08-04T18:25:19Z")

</div>

Sorry, now that I log in to BigQuery I see the datasets I was hoping for. I guess the UI did not refresh and show me the new datasets.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/1X/a7a7ca1fe379aaf90952b0e13118a817babcd14f.png) [@system](https://discourse.getdbt.com/u/system)\
**Post date:** [August 11, 2024, 6:25pm UTC](https://discourse.getdbt.com/t/set-schema-dataset-for-bigquery/13995/5 "2024-08-11T18:25:47Z")

</div>

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