Secure 5.2.1: alterShareTags

alterShareTags

Last updated: August 12, 2026

Sets or removes tags on an existing share in Snowflake.

Note: This change type does not support automatic rollback or database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).

Available attributes

Attribute	Type	Description	Required
`shareName`	String	Name of the share to alter	Yes
`ifExists`	Boolean	Don't error if the share doesn't exist	No
`setTags`	MapWrapper	Key-value pairs of tags to set*	No
`unsetTags`	List<UnsetTag>	List of tag names to remove*	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 tags -->
    <changeSet id="set-share-tags" author="examples">
        <pro-snowflake:alterShareTags shareName="MY_SHARE">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="production"/>
                <pro-snowflake:entry key="data_classification" value="confidential"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterShareTags>
    </changeSet>

    <!-- Set tags with IF EXISTS -->
    <changeSet id="set-share-tags-if-exists" author="examples">
        <pro-snowflake:alterShareTags shareName="MY_SHARE" ifExists="true">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="status" value="active"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterShareTags>
    </changeSet>

    <!-- Unset tags -->
    <changeSet id="unset-share-tags" author="examples">
        <pro-snowflake:alterShareTags shareName="MY_SHARE">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="environment"/>
                <pro-snowflake:unsetTag tagName="data_classification"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterShareTags>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-share-tags",
        "author": "examples",
        "changes": [
          {
            "alterShareTags": {
              "shareName": "MY_SHARE",
              "setTags": {
                "entries": [
                  {
                    "entry": {
                      "key": "environment",
                      "value": "production"
                    }
                  },
                  {
                    "entry": {
                      "key": "data_classification",
                      "value": "confidential"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "set-share-tags-if-exists",
        "author": "examples",
        "changes": [
          {
            "alterShareTags": {
              "shareName": "MY_SHARE",
              "ifExists": true,
              "setTags": {
                "entries": [
                  {
                    "entry": {
                      "key": "status",
                      "value": "active"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-share-tags",
        "author": "examples",
        "changes": [
          {
            "alterShareTags": {
              "shareName": "MY_SHARE",
              "unsetTags": [
                {
                  "unsetTag": {
                    "tagName": "environment"
                  }
                },
                {
                  "unsetTag": {
                    "tagName": "data_classification"
                  }
                }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set tags
  - changeSet:
      id: set-share-tags
      author: examples
      changes:
        - alterShareTags:
            shareName: MY_SHARE
            setTags:
              entries:
                - entry:
                    key: environment
                    value: production
                - entry:
                    key: data_classification
                    value: confidential

  # Set tags with IF EXISTS
  - changeSet:
      id: set-share-tags-if-exists
      author: examples
      changes:
        - alterShareTags:
            shareName: MY_SHARE
            ifExists: true
            setTags:
              entries:
                - entry:
                    key: status
                    value: active

  # Unset tags
  - changeSet:
      id: unset-share-tags
      author: examples
      changes:
        - alterShareTags:
            shareName: MY_SHARE
            unsetTags:
              - unsetTag:
                  tagName: environment
              - unsetTag:
                  tagName: data_classification

--liquibase formatted sql

--changeset examples:set-tags
-- Set tags
ALTER SHARE MY_SHARE SET TAG environment = 'production', data_classification = 'confidential';

--changeset examples:set-tags-with-if-exists
-- Set tags with IF EXISTS
ALTER SHARE IF EXISTS MY_SHARE SET TAG status = 'active';

--changeset examples:unset-tags
-- Unset tags
ALTER SHARE MY_SHARE UNSET TAG environment, data_classification;

<?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 tags -->
    <changeSet id="set-share-tags" author="examples">
        <pro-snowflake:alterShareTags shareName="MY_SHARE">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="production"/>
                <pro-snowflake:entry key="data_classification" value="confidential"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterShareTags>
    </changeSet>

    <!-- Set tags with IF EXISTS -->
    <changeSet id="set-share-tags-if-exists" author="examples">
        <pro-snowflake:alterShareTags shareName="MY_SHARE" ifExists="true">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="status" value="active"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterShareTags>
    </changeSet>

    <!-- Unset tags -->
    <changeSet id="unset-share-tags" author="examples">
        <pro-snowflake:alterShareTags shareName="MY_SHARE">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="environment"/>
                <pro-snowflake:unsetTag tagName="data_classification"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterShareTags>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-share-tags",
        "author": "examples",
        "changes": [
          {
            "alterShareTags": {
              "shareName": "MY_SHARE",
              "setTags": {
                "entries": [
                  {
                    "entry": {
                      "key": "environment",
                      "value": "production"
                    }
                  },
                  {
                    "entry": {
                      "key": "data_classification",
                      "value": "confidential"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "set-share-tags-if-exists",
        "author": "examples",
        "changes": [
          {
            "alterShareTags": {
              "shareName": "MY_SHARE",
              "ifExists": true,
              "setTags": {
                "entries": [
                  {
                    "entry": {
                      "key": "status",
                      "value": "active"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-share-tags",
        "author": "examples",
        "changes": [
          {
            "alterShareTags": {
              "shareName": "MY_SHARE",
              "unsetTags": [
                {
                  "unsetTag": {
                    "tagName": "environment"
                  }
                },
                {
                  "unsetTag": {
                    "tagName": "data_classification"
                  }
                }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set tags
  - changeSet:
      id: set-share-tags
      author: examples
      changes:
        - alterShareTags:
            shareName: MY_SHARE
            setTags:
              entries:
                - entry:
                    key: environment
                    value: production
                - entry:
                    key: data_classification
                    value: confidential

  # Set tags with IF EXISTS
  - changeSet:
      id: set-share-tags-if-exists
      author: examples
      changes:
        - alterShareTags:
            shareName: MY_SHARE
            ifExists: true
            setTags:
              entries:
                - entry:
                    key: status
                    value: active

  # Unset tags
  - changeSet:
      id: unset-share-tags
      author: examples
      changes:
        - alterShareTags:
            shareName: MY_SHARE
            unsetTags:
              - unsetTag:
                  tagName: environment
              - unsetTag:
                  tagName: data_classification

--liquibase formatted sql

--changeset examples:set-tags
-- Set tags
ALTER SHARE MY_SHARE SET TAG environment = 'production', data_classification = 'confidential';

--changeset examples:set-tags-with-if-exists
-- Set tags with IF EXISTS
ALTER SHARE IF EXISTS MY_SHARE SET TAG status = 'active';

--changeset examples:unset-tags
-- Unset tags
ALTER SHARE MY_SHARE UNSET TAG environment, data_classification;

alterShareTags

Available attributes

XML

JSON

YAML

SQL

More like this