search

dbt-labs / dbt-core

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
https://getdbt.com
Apache License 2.0
9.96k stars 1.63k forks source link

[Bug] <Incremental table creation> #10774

Open fsalemi opened 1 month ago

fsalemi commented 1 month ago

Is this a new bug in dbt-core?

Current Behavior

when I try to create a new incremental model in dbt, and run it, it gives me the following error message: Table "my_table" must be qualified with a dataset (e.g. dataset.table).

Expected Behavior

poetry run dbt run --full-refresh -s my_table

Steps To Reproduce

{{ config( materialized='incremental', incremental_strategy='insert_overwrite', partition_by = { 'field': 'dt', 'data_type': 'date', 'granularity': 'day', }, ) }}

Relevant log output

No response

Environment

- OS:
- Python:
- dbt:

Which database adapter are you using with dbt?

No response

Additional Context

No response

dbeatty10 commented 1 month ago

Thanks for reaching out @fsalemi !

Could you share the output of dbt --version so we can see the relevant software versions you are using?

Based on that error message, it looks like you are using the dbt-bigquery adapter.

One thing you could inspect is to see if your dataset: (or schema:) is configured correctly within profiles.yml. You can find the location of your profiles.yml file by running dbt debug. It will start with Using profiles.yml file at.