Hi,
we are having issues with our log_history tables in Snowflake. They are made up in dbt and build with an incremental refresh. So twice a month, we are getting a new dataset added below the previous data with a new timestamp.
So now, the problem is that when a column gets added to the View the log table is built on, the next build of the log table crashes.
The only solution I see is to make a full-refresh to build it from new but i would lose all our data.
Thanks for your help!