How scdtype behaves when we have a new column added to the source table?

230 Views Asked by At

We have built models for our project and it was running fine. We have scdtyp2 models created , incremental models created having all the required data. Issue is occuring when we have a new column being added to the source table.When running the dbt models , we are getting error for scdtype2 models-It fails to recognize the new column added. I have tried using +On-schmema-change : Sync all column configuration , but it is still giving me error . Is there any way to accomodate new columns to the already created scdtype2 tables without droping all these tables?

0

There are 0 best solutions below