Hello everyone, I have a question.
I built an incremental model, and we’ve decided that a certain column is no longer needed, so we want to remove it. I understand that this will change the schema, which may lead to an error.
Doing a full refresh is not an option, as we need to preserve all existing data — the calculations should remain based on the parameters available at the time they were originally computed.
My only option seems to be manually dropping the column and updating the dbt code accordingly. Are there any other alternatives?
Thanks in advance!
If you update the dbt model and remove it from the query you can keep the column and new rows will have null values in that column. If the column doesn’t need to be deleted that would all you to continue without a full refresh.