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 Model Fails When Column Varchar Size Increases (Edge Case) #133

Closed
Tracked by #376
alittlesliceoftom opened this issue Apr 23, 2021 · 1 comment · Fixed by #376
Closed
Tracked by #376

Incremental Model Fails When Column Varchar Size Increases (Edge Case) #133

alittlesliceoftom opened this issue Apr 23, 2021 · 1 comment · Fixed by #376
Labels

Comments

@alittlesliceoftom
Copy link

alittlesliceoftom commented Apr 23, 2021

When an incremental model's varchar size increases beyond the current default e.g. from VARCHAR(50) - (150) , dbt attempts to replace the column, however it makes syntax errors in SQL server:

Actual

ALTER TABLE database.schema.model
ADD COLUMN "Column__dbt_alter" CHARACTER VARYING(200);

Desired

ALTER TABLE database.schema.model
ADD "Column__dbt_alter" VARCHAR(200);

I may be able to add a MRE later.

Dbt 0.19.1

@sdebruyn
Copy link
Member

fixed in #376

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
3 participants