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

Incremental with sync_all_columns passes even if it drops it's partition column #77

Open
ccharlesgb opened this issue Nov 26, 2024 · 0 comments
Labels
bug Something isn't working good first issue Good for newcomers

Comments

@ccharlesgb
Copy link
Collaborator

Steps to Reproduce

Create a partitioned incremental model with on_schema_change='sync_all_columns'

Run dbt and materialise the table

Rename the partition column. The dry run will pass but when running for real you will get the failure:

[base] �[0m11:40:07    Database Error in model my_partitioned_table (models/my_partitioned_table.sql)
[base]   Column `partition_column` cannot be dropped in table `my_partitioned_table`. Columns used in table partitioning or clustering or as part of key constraints cannot be dropped.
@ccharlesgb ccharlesgb added bug Something isn't working good first issue Good for newcomers labels Nov 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

1 participant