The problem I’m having
dbt model sql file + yml, the properties file stores column metatada and for esch column comment a new version is created.
The context of why I’m trying to do this
Materialization table, dbt run model with 300 columns scheduled 4 times/day. Each run creates 300 versions in history.
What I’ve already tried
I’ve tried to override persist_docs (which is set on true at peoject level and I cannot change that) and now I’m thinking about writing a macro that would alter all columns in just one operation but I’m not sure if it is a good approach.