Create or alter tables with tags in?
Hey all, we have several columns in tables that are tagged for certain criteria like PII, Confidential etc. We are trying to build some cicd / devops pipelines to handle deployments to snowflake, and part of that is using create or alter on tables to avoid create or replace.
The problem we have is create or alter on a table with tags on columns gives you:
>CREATE OR ALTER does not support setting policies or tags
The tags are already set on the table, we arent trying to add or set new ones, just running the DDL from GET_DDL with a new column on the end. But the GET_DDL includes the tags, and we dont want the table to be emptied of data so need to use create or alter.
Anyone have any ideas how to work around this because its completely blocked any development of trying to have automated snowflake deployments of objects