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.

Sign up for GitHub

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

Jump to bottom

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

Open
geoff-muldoon opened this issue Aug 5, 2024 · 1 comment
Open

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

geoff-muldoon opened this issue Aug 5, 2024 · 1 comment
Assignees
@matthewshaver
Labels
community Contributions from the dbt community

Comments

@geoff-muldoon
Copy link

geoff-muldoon commented Aug 5, 2024 •
edited
Loading

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@matthewshaver matthewshaver

Labels
community Contributions from the dbt community
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@matthewshaver @geoff-muldoon