Secure 5.2.1: alterRoleTags

alterRoleTags

Last updated: July 13, 2026

Sets or removes tags on an existing role 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
`roleName`	String	Name of the role to alter	Yes
`ifExists`	Boolean	Only alter if the role exists using `IF EXISTS`	No
`setTags`	Map	Key-value pairs of tags to set on the role*	No
`unsetTags`	List	List of tag names to remove from the role*	No

* Exactly one of setTags or unsetTags must be specified. Tags must exist before use.

unsetTag attributes

Attribute	Type	Description	Required
`tagName`	String	Name of tag to remove	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 tags -->
    <changeSet id="role-set-tags" author="examples">
        <pro-snowflake:alterRoleTags roleName="ANALYTICS_ROLE">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="department" value="engineering"/>
                <pro-snowflake:entry key="cost_center" value="CC-1234"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterRoleTags>
    </changeSet>

    <!-- Set tags with IF EXISTS -->
    <changeSet id="role-set-tags-if-exists" author="examples">
        <pro-snowflake:alterRoleTags
                roleName="SERVICE_ROLE"
                ifExists="true">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="production"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterRoleTags>
    </changeSet>

    <!-- Unset tags -->
    <changeSet id="role-unset-tags" author="examples">
        <pro-snowflake:alterRoleTags roleName="ANALYTICS_ROLE">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="department"/>
                <pro-snowflake:unsetTag tagName="cost_center"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterRoleTags>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "role-set-tags",
        "author": "examples",
        "changes": [
          {
            "alterRoleTags": {
              "roleName": "ANALYTICS_ROLE",
              "setTags": {
                "entries": [
                  { "entry": { "key": "department", "value": "engineering" } },
                  { "entry": { "key": "cost_center", "value": "CC-1234" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "role-set-tags-if-exists",
        "author": "examples",
        "changes": [
          {
            "alterRoleTags": {
              "roleName": "SERVICE_ROLE",
              "ifExists": true,
              "setTags": {
                "entries": [
                  { "entry": { "key": "environment", "value": "production" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "role-unset-tags",
        "author": "examples",
        "changes": [
          {
            "alterRoleTags": {
              "roleName": "ANALYTICS_ROLE",
              "unsetTags": [
                { "unsetTag": { "tagName": "department" } },
                { "unsetTag": { "tagName": "cost_center" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set tags
  - changeSet:
      id: role-set-tags
      author: examples
      changes:
        - alterRoleTags:
            roleName: ANALYTICS_ROLE
            setTags:
              entries:
                - entry:
                    key: department
                    value: engineering
                - entry:
                    key: cost_center
                    value: CC-1234

  # Set tags with IF EXISTS
  - changeSet:
      id: role-set-tags-if-exists
      author: examples
      changes:
        - alterRoleTags:
            roleName: SERVICE_ROLE
            ifExists: true
            setTags:
              entries:
                - entry:
                    key: environment
                    value: production

  # Unset tags
  - changeSet:
      id: role-unset-tags
      author: examples
      changes:
        - alterRoleTags:
            roleName: ANALYTICS_ROLE
            unsetTags:
              - unsetTag:
                  tagName: department
              - unsetTag:
                  tagName: cost_center

--liquibase formatted sql

--changeset examples:set-tags
-- Set tags
ALTER ROLE ANALYTICS_ROLE SET TAG department = 'engineering', cost_center = 'CC-1234';

--changeset examples:set-tags-with-if-exists
-- Set tags with IF EXISTS
ALTER ROLE IF EXISTS SERVICE_ROLE SET TAG environment = 'production';

--changeset examples:unset-tags
-- Unset tags
ALTER ROLE ANALYTICS_ROLE UNSET TAG department, cost_center;

<?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="role-set-tags" author="examples">
        <pro-snowflake:alterRoleTags roleName="ANALYTICS_ROLE">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="department" value="engineering"/>
                <pro-snowflake:entry key="cost_center" value="CC-1234"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterRoleTags>
    </changeSet>

    <!-- Set tags with IF EXISTS -->
    <changeSet id="role-set-tags-if-exists" author="examples">
        <pro-snowflake:alterRoleTags
                roleName="SERVICE_ROLE"
                ifExists="true">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="production"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterRoleTags>
    </changeSet>

    <!-- Unset tags -->
    <changeSet id="role-unset-tags" author="examples">
        <pro-snowflake:alterRoleTags roleName="ANALYTICS_ROLE">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="department"/>
                <pro-snowflake:unsetTag tagName="cost_center"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterRoleTags>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "role-set-tags",
        "author": "examples",
        "changes": [
          {
            "alterRoleTags": {
              "roleName": "ANALYTICS_ROLE",
              "setTags": {
                "entries": [
                  { "entry": { "key": "department", "value": "engineering" } },
                  { "entry": { "key": "cost_center", "value": "CC-1234" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "role-set-tags-if-exists",
        "author": "examples",
        "changes": [
          {
            "alterRoleTags": {
              "roleName": "SERVICE_ROLE",
              "ifExists": true,
              "setTags": {
                "entries": [
                  { "entry": { "key": "environment", "value": "production" } }
                ]
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "role-unset-tags",
        "author": "examples",
        "changes": [
          {
            "alterRoleTags": {
              "roleName": "ANALYTICS_ROLE",
              "unsetTags": [
                { "unsetTag": { "tagName": "department" } },
                { "unsetTag": { "tagName": "cost_center" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set tags
  - changeSet:
      id: role-set-tags
      author: examples
      changes:
        - alterRoleTags:
            roleName: ANALYTICS_ROLE
            setTags:
              entries:
                - entry:
                    key: department
                    value: engineering
                - entry:
                    key: cost_center
                    value: CC-1234

  # Set tags with IF EXISTS
  - changeSet:
      id: role-set-tags-if-exists
      author: examples
      changes:
        - alterRoleTags:
            roleName: SERVICE_ROLE
            ifExists: true
            setTags:
              entries:
                - entry:
                    key: environment
                    value: production

  # Unset tags
  - changeSet:
      id: role-unset-tags
      author: examples
      changes:
        - alterRoleTags:
            roleName: ANALYTICS_ROLE
            unsetTags:
              - unsetTag:
                  tagName: department
              - unsetTag:
                  tagName: cost_center

--liquibase formatted sql

--changeset examples:set-tags
-- Set tags
ALTER ROLE ANALYTICS_ROLE SET TAG department = 'engineering', cost_center = 'CC-1234';

--changeset examples:set-tags-with-if-exists
-- Set tags with IF EXISTS
ALTER ROLE IF EXISTS SERVICE_ROLE SET TAG environment = 'production';

--changeset examples:unset-tags
-- Unset tags
ALTER ROLE ANALYTICS_ROLE UNSET TAG department, cost_center;

alterRoleTags

Available attributes

unsetTag attributes

XML example

JSON example

YAML example

SQL example