Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] <Incremental table creation> #10774

Open
2 tasks done
fsalemi opened this issue Sep 25, 2024 · 1 comment
Open
2 tasks done

[Bug] <Incremental table creation> #10774

fsalemi opened this issue Sep 25, 2024 · 1 comment
Labels
awaiting_response bug Something isn't working incremental Incremental modeling with dbt

Comments

@fsalemi
Copy link

fsalemi commented Sep 25, 2024

Is this a new bug in dbt-core?

  • I believe this is a new bug in dbt-core
  • I have searched the existing issues, and I could not find an existing issue for this bug

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

@fsalemi fsalemi added bug Something isn't working triage labels Sep 25, 2024
@dbeatty10 dbeatty10 added the incremental Incremental modeling with dbt label Sep 25, 2024
@dbeatty10
Copy link
Contributor

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 .

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
awaiting_response bug Something isn't working incremental Incremental modeling with dbt
Projects
None yet
Development

No branches or pull requests

2 participants