Alter Dynamic Table - Column

alterDynamicTableColumn

Last updated: February 13, 2026

Modifies column properties on an existing Snowflake dynamic table.

Note: Dynamic table columns are derived from the query, so they have fewer modifiable properties compared to standard table columns. They don't support data type changes, nullable changes, default values, auto-increment, or computed columns.

Note: This change type does not support automatic rollback.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the dynamic table	No
`schemaName`	String	Name of the schema containing the dynamic table	No
`tableName`	String	Name of the dynamic table containing the column	Yes
`columnName`	String	Name of the column to alter	Yes
`ifExists`	Boolean	Only execute if the dynamic table exists	No

Masking policy

Sets or unsets a masking policy on the column.

alterMaskingPolicy nested attributes

Attribute	Type	Description	Required
`policyName`	String	Name of the masking policy to apply	No*
`using`	String	Additional columns for conditional masking	No
`force`	Boolean	If true, forces policy replacement	No
`unsetPolicy`	Boolean	If true, removes the masking policy	No*

*Specify either policyName to set or unsetPolicy to remove.

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set masking policy -->
    <changeSet id="set-masking-policy" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="EMAIL">
            <pro-snowflake:alterMaskingPolicy policyName="EMAIL_MASK" force="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Set masking policy with conditional columns -->
    <changeSet id="set-masking-policy-conditional" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="SSN">
            <pro-snowflake:alterMaskingPolicy
                policyName="SSN_MASK"
                using="ROLE_COLUMN"
                force="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Unset masking policy -->
    <changeSet id="unset-masking-policy" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="EMAIL">
            <pro-snowflake:alterMaskingPolicy unsetPolicy="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  # Set masking policy
  - changeSet:
      id: set-masking-policy
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: EMAIL
            alterMaskingPolicy:
              policyName: EMAIL_MASK
              force: true

  # Set masking policy with conditional columns
  - changeSet:
      id: set-masking-policy-conditional
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: SSN
            alterMaskingPolicy:
              policyName: SSN_MASK
              using: ROLE_COLUMN
              force: true

  # Unset masking policy
  - changeSet:
      id: unset-masking-policy
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: EMAIL
            alterMaskingPolicy:
              unsetPolicy: true

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-masking-policy",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "EMAIL",
              "alterMaskingPolicy": {
                "policyName": "EMAIL_MASK",
                "force": true
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "set-masking-policy-conditional",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "SSN",
              "alterMaskingPolicy": {
                "policyName": "SSN_MASK",
                "using": "ROLE_COLUMN",
                "force": true
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-masking-policy",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "EMAIL",
              "alterMaskingPolicy": {
                "unsetPolicy": true
              }
            }
          }
        ]
      }
    }
  ]
}

--liquibase formatted sql

--changeset examples:set-masking-policy
-- Set masking policy
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN EMAIL SET MASKING POLICY EMAIL_MASK FORCE;

--changeset examples:set-masking-policy-with-conditional-columns
-- Set masking policy with conditional columns
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN SSN SET MASKING POLICY SSN_MASK USING (SSN, ROLE_COLUMN) FORCE;

--changeset examples:unset-masking-policy
-- Unset masking policy
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN EMAIL UNSET MASKING POLICY;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set masking policy -->
    <changeSet id="set-masking-policy" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="EMAIL">
            <pro-snowflake:alterMaskingPolicy policyName="EMAIL_MASK" force="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Set masking policy with conditional columns -->
    <changeSet id="set-masking-policy-conditional" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="SSN">
            <pro-snowflake:alterMaskingPolicy
                policyName="SSN_MASK"
                using="ROLE_COLUMN"
                force="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Unset masking policy -->
    <changeSet id="unset-masking-policy" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="EMAIL">
            <pro-snowflake:alterMaskingPolicy unsetPolicy="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  # Set masking policy
  - changeSet:
      id: set-masking-policy
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: EMAIL
            alterMaskingPolicy:
              policyName: EMAIL_MASK
              force: true

  # Set masking policy with conditional columns
  - changeSet:
      id: set-masking-policy-conditional
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: SSN
            alterMaskingPolicy:
              policyName: SSN_MASK
              using: ROLE_COLUMN
              force: true

  # Unset masking policy
  - changeSet:
      id: unset-masking-policy
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: EMAIL
            alterMaskingPolicy:
              unsetPolicy: true

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-masking-policy",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "EMAIL",
              "alterMaskingPolicy": {
                "policyName": "EMAIL_MASK",
                "force": true
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "set-masking-policy-conditional",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "SSN",
              "alterMaskingPolicy": {
                "policyName": "SSN_MASK",
                "using": "ROLE_COLUMN",
                "force": true
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-masking-policy",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "EMAIL",
              "alterMaskingPolicy": {
                "unsetPolicy": true
              }
            }
          }
        ]
      }
    }
  ]
}

--liquibase formatted sql

--changeset examples:set-masking-policy
-- Set masking policy
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN EMAIL SET MASKING POLICY EMAIL_MASK FORCE;

--changeset examples:set-masking-policy-with-conditional-columns
-- Set masking policy with conditional columns
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN SSN SET MASKING POLICY SSN_MASK USING (SSN, ROLE_COLUMN) FORCE;

--changeset examples:unset-masking-policy
-- Unset masking policy
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN EMAIL UNSET MASKING POLICY;

Projection policy

Sets or unsets a projection policy on the column.

alterProjectionPolicy nested attributes

Attribute	Type	Description	Required
`policyName`	String	Name of the projection policy	No*
`force`	Boolean	If true, forces policy replacement	No
`unsetPolicy`	Boolean	If true, removes the projection policy	No*

*Specify either policyName to set or unsetPolicy to remove.

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set projection policy -->
    <changeSet id="set-projection-policy" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="SECRET_COLUMN">
            <pro-snowflake:alterProjectionPolicy policyName="NO_PROJECTION" force="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Unset projection policy -->
    <changeSet id="unset-projection-policy" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="SECRET_COLUMN">
            <pro-snowflake:alterProjectionPolicy unsetPolicy="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  # Set projection policy
  - changeSet:
      id: set-projection-policy
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: SECRET_COLUMN
            alterProjectionPolicy:
              policyName: NO_PROJECTION
              force: true

  # Unset projection policy
  - changeSet:
      id: unset-projection-policy
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: SECRET_COLUMN
            alterProjectionPolicy:
              unsetPolicy: true

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-projection-policy",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "SECRET_COLUMN",
              "alterProjectionPolicy": {
                "policyName": "NO_PROJECTION",
                "force": true
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-projection-policy",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "SECRET_COLUMN",
              "alterProjectionPolicy": {
                "unsetPolicy": true
              }
            }
          }
        ]
      }
    }
  ]
}

-- Set projection policy
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN SECRET_COLUMN SET PROJECTION POLICY NO_PROJECTION FORCE;

-- Unset projection policy
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN SECRET_COLUMN UNSET PROJECTION POLICY;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set projection policy -->
    <changeSet id="set-projection-policy" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="SECRET_COLUMN">
            <pro-snowflake:alterProjectionPolicy policyName="NO_PROJECTION" force="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Unset projection policy -->
    <changeSet id="unset-projection-policy" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="SECRET_COLUMN">
            <pro-snowflake:alterProjectionPolicy unsetPolicy="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  # Set projection policy
  - changeSet:
      id: set-projection-policy
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: SECRET_COLUMN
            alterProjectionPolicy:
              policyName: NO_PROJECTION
              force: true

  # Unset projection policy
  - changeSet:
      id: unset-projection-policy
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: SECRET_COLUMN
            alterProjectionPolicy:
              unsetPolicy: true

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-projection-policy",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "SECRET_COLUMN",
              "alterProjectionPolicy": {
                "policyName": "NO_PROJECTION",
                "force": true
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-projection-policy",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "SECRET_COLUMN",
              "alterProjectionPolicy": {
                "unsetPolicy": true
              }
            }
          }
        ]
      }
    }
  ]
}

-- Set projection policy
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN SECRET_COLUMN SET PROJECTION POLICY NO_PROJECTION FORCE;

-- Unset projection policy
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN SECRET_COLUMN UNSET PROJECTION POLICY;

Comment

Sets or unsets the column comment.

alterColumnComment nested attributes

Attribute	Type	Description	Required
`newComment`	String	New comment text	No*
`unsetComment`	Boolean	If true, removes the comment	No*

*Exactly one of newComment or unsetComment must be specified.

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set column comment -->
    <changeSet id="set-column-comment" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="MY_COLUMN">
            <pro-snowflake:alterColumnComment newComment="Aggregated customer data"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Remove column comment -->
    <changeSet id="unset-column-comment" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="MY_COLUMN">
            <pro-snowflake:alterColumnComment unsetComment="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  # Set column comment
  - changeSet:
      id: set-column-comment
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: MY_COLUMN
            alterColumnComment:
              newComment: "Aggregated customer data"

  # Remove column comment
  - changeSet:
      id: unset-column-comment
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: MY_COLUMN
            alterColumnComment:
              unsetComment: true

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-column-comment",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "MY_COLUMN",
              "alterColumnComment": {
                "newComment": "Aggregated customer data"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-column-comment",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "MY_COLUMN",
              "alterColumnComment": {
                "unsetComment": true
              }
            }
          }
        ]
      }
    }
  ]
}

-- Set column comment
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN MY_COLUMN SET COMMENT 'Aggregated customer data';

-- Remove column comment
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN MY_COLUMN UNSET COMMENT;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set column comment -->
    <changeSet id="set-column-comment" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="MY_COLUMN">
            <pro-snowflake:alterColumnComment newComment="Aggregated customer data"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Remove column comment -->
    <changeSet id="unset-column-comment" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="MY_COLUMN">
            <pro-snowflake:alterColumnComment unsetComment="true"/>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  # Set column comment
  - changeSet:
      id: set-column-comment
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: MY_COLUMN
            alterColumnComment:
              newComment: "Aggregated customer data"

  # Remove column comment
  - changeSet:
      id: unset-column-comment
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: MY_COLUMN
            alterColumnComment:
              unsetComment: true

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-column-comment",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "MY_COLUMN",
              "alterColumnComment": {
                "newComment": "Aggregated customer data"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-column-comment",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "MY_COLUMN",
              "alterColumnComment": {
                "unsetComment": true
              }
            }
          }
        ]
      }
    }
  ]
}

-- Set column comment
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN MY_COLUMN SET COMMENT 'Aggregated customer data';

-- Remove column comment
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN MY_COLUMN UNSET COMMENT;

Tags

Sets or unsets tags on the column.

alterColumnTags nested attributes

Attribute	Type	Description	Required
`setTags`	Object	Map of tag names to values to set	No*
`unsetTags`	Object	List of tag names to unset	No*

*Exactly one of setTags or unsetTags must be specified.

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set column tags -->
    <changeSet id="set-column-tags" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="AGGREGATED_DATA">
            <pro-snowflake:alterColumnTags>
                <pro-snowflake:setTags>
                    <pro-snowflake:entry key="PII" value="false"/>
                    <pro-snowflake:entry key="DATA_TYPE" value="AGGREGATE"/>
                </pro-snowflake:setTags>
            </pro-snowflake:alterColumnTags>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Unset column tags -->
    <changeSet id="unset-column-tags" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="AGGREGATED_DATA">
            <pro-snowflake:alterColumnTags>
                <pro-snowflake:unsetTags>
                    <pro-snowflake:unsetTag tagName="PII"/>
                    <pro-snowflake:unsetTag tagName="DATA_TYPE"/>
                </pro-snowflake:unsetTags>
            </pro-snowflake:alterColumnTags>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  # Set column tags
  - changeSet:
      id: set-column-tags
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: AGGREGATED_DATA
            alterColumnTags:
              setTags:
                - entry:
                    key: PII
                    value: "false"
                - entry:
                    key: DATA_TYPE
                    value: AGGREGATE

  # Unset column tags
  - changeSet:
      id: unset-column-tags
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: AGGREGATED_DATA
            alterColumnTags:
              unsetTags:
                - unsetTag:
                    tagName: PII
                - unsetTag:
                    tagName: DATA_TYPE

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-column-tags",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "AGGREGATED_DATA",
              "alterColumnTags": {
                "setTags": [
                  {
                    "entry": {
                      "key": "PII",
                      "value": "false"
                    }
                  },
                  {
                    "entry": {
                      "key": "DATA_TYPE",
                      "value": "AGGREGATE"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-column-tags",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "AGGREGATED_DATA",
              "alterColumnTags": {
                "unsetTags": [
                  {
                    "unsetTag": {
                      "tagName": "PII"
                    }
                  },
                  {
                    "unsetTag": {
                      "tagName": "DATA_TYPE"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    }
  ]
}

-- Set column tags
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN AGGREGATED_DATA SET TAG PII = 'false', DATA_TYPE = 'AGGREGATE';

-- Unset column tags
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN AGGREGATED_DATA UNSET TAG PII, DATA_TYPE;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set column tags -->
    <changeSet id="set-column-tags" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="AGGREGATED_DATA">
            <pro-snowflake:alterColumnTags>
                <pro-snowflake:setTags>
                    <pro-snowflake:entry key="PII" value="false"/>
                    <pro-snowflake:entry key="DATA_TYPE" value="AGGREGATE"/>
                </pro-snowflake:setTags>
            </pro-snowflake:alterColumnTags>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

    <!-- Unset column tags -->
    <changeSet id="unset-column-tags" author="examples">
        <pro-snowflake:alterDynamicTableColumn tableName="MY_DYNAMIC_TABLE" columnName="AGGREGATED_DATA">
            <pro-snowflake:alterColumnTags>
                <pro-snowflake:unsetTags>
                    <pro-snowflake:unsetTag tagName="PII"/>
                    <pro-snowflake:unsetTag tagName="DATA_TYPE"/>
                </pro-snowflake:unsetTags>
            </pro-snowflake:alterColumnTags>
        </pro-snowflake:alterDynamicTableColumn>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  # Set column tags
  - changeSet:
      id: set-column-tags
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: AGGREGATED_DATA
            alterColumnTags:
              setTags:
                - entry:
                    key: PII
                    value: "false"
                - entry:
                    key: DATA_TYPE
                    value: AGGREGATE

  # Unset column tags
  - changeSet:
      id: unset-column-tags
      author: examples
      changes:
        - alterDynamicTableColumn:
            tableName: MY_DYNAMIC_TABLE
            columnName: AGGREGATED_DATA
            alterColumnTags:
              unsetTags:
                - unsetTag:
                    tagName: PII
                - unsetTag:
                    tagName: DATA_TYPE

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-column-tags",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "AGGREGATED_DATA",
              "alterColumnTags": {
                "setTags": [
                  {
                    "entry": {
                      "key": "PII",
                      "value": "false"
                    }
                  },
                  {
                    "entry": {
                      "key": "DATA_TYPE",
                      "value": "AGGREGATE"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-column-tags",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTableColumn": {
              "tableName": "MY_DYNAMIC_TABLE",
              "columnName": "AGGREGATED_DATA",
              "alterColumnTags": {
                "unsetTags": [
                  {
                    "unsetTag": {
                      "tagName": "PII"
                    }
                  },
                  {
                    "unsetTag": {
                      "tagName": "DATA_TYPE"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    }
  ]
}

-- Set column tags
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN AGGREGATED_DATA SET TAG PII = 'false', DATA_TYPE = 'AGGREGATE';

-- Unset column tags
ALTER DYNAMIC TABLE MY_DYNAMIC_TABLE MODIFY COLUMN AGGREGATED_DATA UNSET TAG PII, DATA_TYPE;