Secure 5.2.1: alterMaterializedViewTags

alterMaterializedViewTags

Last updated: July 13, 2026

Sets or unsets tags on a materialized view in Snowflake. Tags provide metadata for governance, cost tracking, and data classification. Materialized views require Snowflake Enterprise Edition or higher.

Note: This change type does not support automatic rollback or database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands). Tags must be created before they can be applied to objects.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the materialized view	No
`schemaName`	String	Name of the schema containing the materialized view	No
`viewName`	String	Name of the materialized view to alter	Yes
`setTags`	Nested	Key-value pairs of tags to set*	No
`unsetTags`	Nested	List of tag names to remove*	No

*Exactly one of setTags or unsetTags must be specified.

setTags attributes

Attribute	Type	Description	Required
`key`	String	Tag name	Yes
`value`	String	Tag value	Yes

unsetTags attributes

Attribute	Type	Description	Required
`tagName`	String	Name of tag to unset	Yes

<?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 single tag -->
    <changeSet id="mv-set-single-tag" author="examples">
        <pro-snowflake:alterMaterializedViewTags viewName="MV_INVENTORY">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="production"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterMaterializedViewTags>
    </changeSet>

    <!-- Set multiple tags -->
    <changeSet id="mv-set-multiple-tags" author="examples">
        <pro-snowflake:alterMaterializedViewTags
                schemaName="PUBLIC"
                viewName="MV_INVENTORY">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="staging"/>
                <pro-snowflake:entry key="department" value="warehouse"/>
                <pro-snowflake:entry key="team" value="logistics"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterMaterializedViewTags>
    </changeSet>

    <!-- Unset single tag -->
    <changeSet id="mv-unset-single-tag" author="examples">
        <pro-snowflake:alterMaterializedViewTags viewName="MV_INVENTORY">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="team"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterMaterializedViewTags>
    </changeSet>

    <!-- Unset multiple tags -->
    <changeSet id="mv-unset-multiple-tags" author="examples">
        <pro-snowflake:alterMaterializedViewTags viewName="MV_INVENTORY">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="environment"/>
                <pro-snowflake:unsetTag tagName="department"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterMaterializedViewTags>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "mv-set-single-tag",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewTags": {
              "viewName": "MV_INVENTORY",
              "setTags": {
                "entries": [
                  { "entry": { "key": "environment", "value": "production" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-set-multiple-tags",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewTags": {
              "schemaName": "PUBLIC",
              "viewName": "MV_INVENTORY",
              "setTags": {
                "entries": [
                  { "entry": { "key": "environment", "value": "staging" } },
                  { "entry": { "key": "department", "value": "warehouse" } },
                  { "entry": { "key": "team", "value": "logistics" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-unset-single-tag",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewTags": {
              "viewName": "MV_INVENTORY",
              "unsetTags": [
                { "unsetTag": { "tagName": "team" } }
              ]
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-unset-multiple-tags",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewTags": {
              "viewName": "MV_INVENTORY",
              "unsetTags": [
                { "unsetTag": { "tagName": "environment" } },
                { "unsetTag": { "tagName": "department" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set single tag
  - changeSet:
      id: mv-set-single-tag
      author: examples
      changes:
        - alterMaterializedViewTags:
            viewName: MV_INVENTORY
            setTags:
              entries:
                - entry:
                    key: environment
                    value: production

  # Set multiple tags
  - changeSet:
      id: mv-set-multiple-tags
      author: examples
      changes:
        - alterMaterializedViewTags:
            schemaName: PUBLIC
            viewName: MV_INVENTORY
            setTags:
              entries:
                - entry:
                    key: environment
                    value: staging
                - entry:
                    key: department
                    value: warehouse
                - entry:
                    key: team
                    value: logistics

  # Unset single tag
  - changeSet:
      id: mv-unset-single-tag
      author: examples
      changes:
        - alterMaterializedViewTags:
            viewName: MV_INVENTORY
            unsetTags:
              - unsetTag:
                  tagName: team

  # Unset multiple tags
  - changeSet:
      id: mv-unset-multiple-tags
      author: examples
      changes:
        - alterMaterializedViewTags:
            viewName: MV_INVENTORY
            unsetTags:
              - unsetTag:
                  tagName: environment
              - unsetTag:
                  tagName: department

--liquibase formatted sql

--changeset examples:set-single-tag
-- Set single tag
ALTER VIEW PUBLIC.MV_INVENTORY SET TAG environment = 'production';

--changeset examples:set-multiple-tags
-- Set multiple tags
ALTER VIEW PUBLIC.MV_INVENTORY SET TAG environment = 'staging', department = 'warehouse', team = 'logistics';

--changeset examples:unset-single-tag
-- Unset single tag
ALTER VIEW PUBLIC.MV_INVENTORY UNSET TAG team;

--changeset examples:unset-multiple-tags
-- Unset multiple tags
ALTER VIEW PUBLIC.MV_INVENTORY UNSET TAG environment, department;

<?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 single tag -->
    <changeSet id="mv-set-single-tag" author="examples">
        <pro-snowflake:alterMaterializedViewTags viewName="MV_INVENTORY">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="production"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterMaterializedViewTags>
    </changeSet>

    <!-- Set multiple tags -->
    <changeSet id="mv-set-multiple-tags" author="examples">
        <pro-snowflake:alterMaterializedViewTags
                schemaName="PUBLIC"
                viewName="MV_INVENTORY">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="staging"/>
                <pro-snowflake:entry key="department" value="warehouse"/>
                <pro-snowflake:entry key="team" value="logistics"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterMaterializedViewTags>
    </changeSet>

    <!-- Unset single tag -->
    <changeSet id="mv-unset-single-tag" author="examples">
        <pro-snowflake:alterMaterializedViewTags viewName="MV_INVENTORY">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="team"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterMaterializedViewTags>
    </changeSet>

    <!-- Unset multiple tags -->
    <changeSet id="mv-unset-multiple-tags" author="examples">
        <pro-snowflake:alterMaterializedViewTags viewName="MV_INVENTORY">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="environment"/>
                <pro-snowflake:unsetTag tagName="department"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterMaterializedViewTags>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "mv-set-single-tag",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewTags": {
              "viewName": "MV_INVENTORY",
              "setTags": {
                "entries": [
                  { "entry": { "key": "environment", "value": "production" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-set-multiple-tags",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewTags": {
              "schemaName": "PUBLIC",
              "viewName": "MV_INVENTORY",
              "setTags": {
                "entries": [
                  { "entry": { "key": "environment", "value": "staging" } },
                  { "entry": { "key": "department", "value": "warehouse" } },
                  { "entry": { "key": "team", "value": "logistics" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-unset-single-tag",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewTags": {
              "viewName": "MV_INVENTORY",
              "unsetTags": [
                { "unsetTag": { "tagName": "team" } }
              ]
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "mv-unset-multiple-tags",
        "author": "examples",
        "changes": [
          {
            "alterMaterializedViewTags": {
              "viewName": "MV_INVENTORY",
              "unsetTags": [
                { "unsetTag": { "tagName": "environment" } },
                { "unsetTag": { "tagName": "department" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set single tag
  - changeSet:
      id: mv-set-single-tag
      author: examples
      changes:
        - alterMaterializedViewTags:
            viewName: MV_INVENTORY
            setTags:
              entries:
                - entry:
                    key: environment
                    value: production

  # Set multiple tags
  - changeSet:
      id: mv-set-multiple-tags
      author: examples
      changes:
        - alterMaterializedViewTags:
            schemaName: PUBLIC
            viewName: MV_INVENTORY
            setTags:
              entries:
                - entry:
                    key: environment
                    value: staging
                - entry:
                    key: department
                    value: warehouse
                - entry:
                    key: team
                    value: logistics

  # Unset single tag
  - changeSet:
      id: mv-unset-single-tag
      author: examples
      changes:
        - alterMaterializedViewTags:
            viewName: MV_INVENTORY
            unsetTags:
              - unsetTag:
                  tagName: team

  # Unset multiple tags
  - changeSet:
      id: mv-unset-multiple-tags
      author: examples
      changes:
        - alterMaterializedViewTags:
            viewName: MV_INVENTORY
            unsetTags:
              - unsetTag:
                  tagName: environment
              - unsetTag:
                  tagName: department

--liquibase formatted sql

--changeset examples:set-single-tag
-- Set single tag
ALTER VIEW PUBLIC.MV_INVENTORY SET TAG environment = 'production';

--changeset examples:set-multiple-tags
-- Set multiple tags
ALTER VIEW PUBLIC.MV_INVENTORY SET TAG environment = 'staging', department = 'warehouse', team = 'logistics';

--changeset examples:unset-single-tag
-- Unset single tag
ALTER VIEW PUBLIC.MV_INVENTORY UNSET TAG team;

--changeset examples:unset-multiple-tags
-- Unset multiple tags
ALTER VIEW PUBLIC.MV_INVENTORY UNSET TAG environment, department;

alterMaterializedViewTags

Available attributes

setTags attributes

unsetTags attributes

XML example

JSON example

YAML example

SQL example

More like this