We use Snowflake and dbt core. Snowflake provides nice, user-friendly UIs to directly enter data governance metadata (snowflake object tags and descriptions). The problem is that dbt can drop this metadata during a build due to normal Snowflake object recreations. So we need to either get Snowflake metadata synced into dbt metadata before object recreations - OR - find a nice UI (that our data stewards can use) to enter metadata into dbt YAML files. What do most people do out in the world?
An alternative solution might be to use a dbt pre-hook to backup Snowflake-entered metadata in a table before dbt object recreations and then a dbt post-hook to re-insert lost metadata in Snowflake. Is that a common solution? Are there holes in this solution?