On Incremental model schema upgrade

[santoshkrs]

Hi All,

We are using the incremental model in one of the applications. We are already in production, due to some business requirements we have allocated model member attributes with VARCHAR(19) and now changed the same to VARCHAR(256). This works fine in the fresh deployment but fails in the upgrade time.

Due to customer data, we can't execute the "dbt run --full-refresh " as the customer will lose the data. Please suggest to us how to handle this in upgrade time without the help of dbt flag i.e. --full-refresh.

Dbt command:
Below the command, we run always for the scheduled job once a day
dbt run -m <folder_name> --vars "{'product_tag':'<tag_name>','product_name':'<product_name>','lite_mau_max_limit':20}"

Thanks & Best Regards
-Santosh