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

dbt-core incremental model with --full-refresh failing on Azure Synapse after initial creation #5895

Closed
geoff-muldoon opened this issue Aug 5, 2024 · 2 comments
Assignees
Labels
community Contributions from the dbt community

Comments

@geoff-muldoon
Copy link

geoff-muldoon commented Aug 5, 2024

After successfully creating and running an incremental table model using dbt-core and the dbt-synapse adapter, if I attempt to recreate the table by using the --full-refresh command line option, I get an error:
[42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'real table name here' in the database. (2714) (SQLExecDirectW)"

It appears that the expected "drop table" script component is not executing?

@matthewshaver
Copy link
Contributor

Hi @geoff-muldoon This issue repo is for our docs.getdbt.com site. Is there a page there you believe is leading you astray?

@matthewshaver matthewshaver self-assigned this Dec 9, 2024
@matthewshaver matthewshaver added the community Contributions from the dbt community label Dec 10, 2024
@mirnawong1
Copy link
Contributor

hey @geoff-muldoon ! thanks for raising this. it looks like you might want to raise an issue with dbt synapse or dbt core.

this repo is for the docs.getdbt.com site. i'll go ahead and close this issue for you but let us know if it should be reopened!

@mirnawong1 mirnawong1 closed this as not planned Won't fix, can't repro, duplicate, stale Jan 9, 2025
@mirnawong1 mirnawong1 self-assigned this Jan 9, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
community Contributions from the dbt community
Projects
None yet
Development

No branches or pull requests

3 participants