Secure 5.2.1: alterWarehouseTags

alterWarehouseTags

Last updated: August 12, 2026

Sets or unsets tags on an existing Snowflake warehouse.

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
`warehouseName`	String	Name of the warehouse to alter	Yes
`ifExists`	Boolean	If true, only alters if the warehouse exists	No
`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.

Nested elements

setTags (MapWrapper) - Key-value pairs of tags to set:

Element	Attribute	Description	Required
`entry`	`key`	Tag name	Yes
`entry`	`value`	Tag value	Yes

unsetTags - Tags to remove:

Element	Attribute	Description	Required
`unsetTag`	`tagName`	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="set-tags" author="examples">
        <pro-snowflake:alterWarehouseTags warehouseName="COMPUTE_WH">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="production"/>
                <pro-snowflake:entry key="cost_center" value="analytics"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterWarehouseTags>
    </changeSet>

    <!-- Unset tags -->
    <changeSet id="unset-tags" author="examples">
        <pro-snowflake:alterWarehouseTags warehouseName="COMPUTE_WH" ifExists="true">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="cost_center"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterWarehouseTags>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-tags",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseTags": {
              "warehouseName": "COMPUTE_WH",
              "setTags": [
                {"entry": {"key": "environment", "value": "production"}},
                {"entry": {"key": "cost_center", "value": "analytics"}}
              ]
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-tags",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseTags": {
              "warehouseName": "COMPUTE_WH",
              "ifExists": true,
              "unsetTags": [
                {"unsetTag": {"tagName": "cost_center"}}
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set tags
  - changeSet:
      id: set-tags
      author: examples
      changes:
        - alterWarehouseTags:
            warehouseName: COMPUTE_WH
            setTags:
              - entry:
                  key: environment
                  value: production
              - entry:
                  key: cost_center
                  value: analytics

  # Unset tags
  - changeSet:
      id: unset-tags
      author: examples
      changes:
        - alterWarehouseTags:
            warehouseName: COMPUTE_WH
            ifExists: true
            unsetTags:
              - unsetTag:
                  tagName: cost_center

--liquibase formatted sql

--changeset examples:set-tags
-- Set tags
ALTER WAREHOUSE COMPUTE_WH SET TAG environment = 'production', cost_center = 'analytics';

--changeset examples:unset-tags
-- Unset tags
ALTER WAREHOUSE IF EXISTS COMPUTE_WH UNSET TAG 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="set-tags" author="examples">
        <pro-snowflake:alterWarehouseTags warehouseName="COMPUTE_WH">
            <pro-snowflake:setTags>
                <pro-snowflake:entry key="environment" value="production"/>
                <pro-snowflake:entry key="cost_center" value="analytics"/>
            </pro-snowflake:setTags>
        </pro-snowflake:alterWarehouseTags>
    </changeSet>

    <!-- Unset tags -->
    <changeSet id="unset-tags" author="examples">
        <pro-snowflake:alterWarehouseTags warehouseName="COMPUTE_WH" ifExists="true">
            <pro-snowflake:unsetTags>
                <pro-snowflake:unsetTag tagName="cost_center"/>
            </pro-snowflake:unsetTags>
        </pro-snowflake:alterWarehouseTags>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-tags",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseTags": {
              "warehouseName": "COMPUTE_WH",
              "setTags": [
                {"entry": {"key": "environment", "value": "production"}},
                {"entry": {"key": "cost_center", "value": "analytics"}}
              ]
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-tags",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseTags": {
              "warehouseName": "COMPUTE_WH",
              "ifExists": true,
              "unsetTags": [
                {"unsetTag": {"tagName": "cost_center"}}
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set tags
  - changeSet:
      id: set-tags
      author: examples
      changes:
        - alterWarehouseTags:
            warehouseName: COMPUTE_WH
            setTags:
              - entry:
                  key: environment
                  value: production
              - entry:
                  key: cost_center
                  value: analytics

  # Unset tags
  - changeSet:
      id: unset-tags
      author: examples
      changes:
        - alterWarehouseTags:
            warehouseName: COMPUTE_WH
            ifExists: true
            unsetTags:
              - unsetTag:
                  tagName: cost_center

--liquibase formatted sql

--changeset examples:set-tags
-- Set tags
ALTER WAREHOUSE COMPUTE_WH SET TAG environment = 'production', cost_center = 'analytics';

--changeset examples:unset-tags
-- Unset tags
ALTER WAREHOUSE IF EXISTS COMPUTE_WH UNSET TAG cost_center;

alterWarehouseTags

Available attributes

Nested elements

XML

JSON

YAML

SQL