# Help with DBT CLI and Dataset Naming in BigQuery

**URL:** <https://discourse.getdbt.com/t/help-with-dbt-cli-and-dataset-naming-in-bigquery/19846>\
**Category:** Help\
**Tags:** bigquery, cli, dbt-core\
**Created:** [July 14, 2025, 9:27am UTC](https://discourse.getdbt.com/t/help-with-dbt-cli-and-dataset-naming-in-bigquery/19846 "2025-07-14T09:27:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![raihan](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/raihan/32/4974_2.png) [@raihan](https://discourse.getdbt.com/u/raihan)\
**Post date:** [July 14, 2025, 9:27am UTC](https://discourse.getdbt.com/t/help-with-dbt-cli-and-dataset-naming-in-bigquery/19846/1 "2025-07-14T09:27:20Z")

</div>

## The problem I’m having

I’m using dbt CLI for data transformations in BigQuery, and I’m encountering an issue with how datasets are named after transformations. When I specify a dataset during project initialization (e.g., ‘abc’), the transformation results are being loaded with an unintended naming pattern in BigQuery. The name ends up being something like ‘abc\_silver\_abc’, instead of just the intended ‘silver\_abc’.

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

I want to load my transformation results into a dataset I created, such as ‘silver\_abc’, without dbt appending the original dataset name (e.g., ‘abc’) to it.

I’ve configured the SQL file to overwrite the data and tried specifying the desired schema, but the issue persists.

```auto
{{ config(
    materialized='table',
    schema='silver_abc',
) }}

```

Despite the configuration, the dataset in BigQuery is being named ‘abc\_silver\_abc’.

---

<div class="post-metadata">

**Author:** ![a\_slack\_user](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/a_slack_user/32/1629_2.png) [@a\_slack\_user](https://discourse.getdbt.com/u/a_slack_user)\
**Post date:** [July 14, 2025, 9:37am UTC](https://discourse.getdbt.com/t/help-with-dbt-cli-and-dataset-naming-in-bigquery/19846/2 "2025-07-14T09:37:20Z")

</div>

[https://docs.getdbt.com/docs/build/custom-schemas#changing-the-way-dbt-generates-a-schema-name](https://docs.getdbt.com/docs/build/custom-schemas#changing-the-way-dbt-generates-a-schema-name)  
this should do

Note: `@malte.niederstadt` originally [posted this reply in Slack](https://getdbt.slack.com/archives/CBSQTAPLG/p1752485829958829?thread_ts=1752485265.890019&cid=CBSQTAPLG). It might not have transferred perfectly.

---

<div class="post-metadata">

**Author:** ![raihan](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/raihan/32/4974_2.png) [@raihan](https://discourse.getdbt.com/u/raihan)\
**Post date:** [July 14, 2025, 9:50am UTC](https://discourse.getdbt.com/t/help-with-dbt-cli-and-dataset-naming-in-bigquery/19846/3 "2025-07-14T09:50:57Z")

</div>

Thank you for help! It’s work

---

<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:** [July 21, 2025, 9:50am UTC](https://discourse.getdbt.com/t/help-with-dbt-cli-and-dataset-naming-in-bigquery/19846/4 "2025-07-21T09:50:59Z")

</div>

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