alterWarehouseState

Last updated: January 27, 2026

Suspends or resumes a Snowflake warehouse. Suspended warehouses do not consume credits but queries cannot be executed against them.

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 modify	Yes
`state`	String	Target state: `suspend`, `resume`, or `resumeIfSuspended`	Yes
`ifExists`	Boolean	If true, do not throw an error if the warehouse does not exist	No

State values

Value	Description
`suspend`	Suspends the warehouse, stopping all queries
`resume`	Resumes a suspended warehouse
`resumeIfSuspended`	Resumes only if currently suspended (idempotent)

<?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">

    <!-- Suspend warehouse -->
    <changeSet id="suspend-warehouse" author="examples">
        <pro-snowflake:alterWarehouseState
            warehouseName="ANALYTICS_WH"
            state="suspend"/>
    </changeSet>

    <!-- Resume warehouse -->
    <changeSet id="resume-warehouse" author="examples">
        <pro-snowflake:alterWarehouseState
            warehouseName="ANALYTICS_WH"
            state="resume"/>
    </changeSet>

    <!-- Resume if suspended (idempotent) -->
    <changeSet id="resume-if-suspended" author="examples">
        <pro-snowflake:alterWarehouseState
            warehouseName="ANALYTICS_WH"
            ifExists="true"
            state="resumeIfSuspended"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "suspend-warehouse",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseState": {
              "warehouseName": "ANALYTICS_WH",
              "state": "suspend"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "resume-warehouse",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseState": {
              "warehouseName": "ANALYTICS_WH",
              "state": "resume"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "resume-if-suspended",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseState": {
              "warehouseName": "ANALYTICS_WH",
              "ifExists": true,
              "state": "resumeIfSuspended"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Suspend warehouse
  - changeSet:
      id: suspend-warehouse
      author: examples
      changes:
        - alterWarehouseState:
            warehouseName: ANALYTICS_WH
            state: suspend

  # Resume warehouse
  - changeSet:
      id: resume-warehouse
      author: examples
      changes:
        - alterWarehouseState:
            warehouseName: ANALYTICS_WH
            state: resume

  # Resume if suspended (idempotent)
  - changeSet:
      id: resume-if-suspended
      author: examples
      changes:
        - alterWarehouseState:
            warehouseName: ANALYTICS_WH
            ifExists: true
            state: resumeIfSuspended

--liquibase formatted sql

--changeset examples:suspend-warehouse
-- Suspend warehouse
ALTER WAREHOUSE ANALYTICS_WH SUSPEND;

--changeset examples:resume-warehouse
-- Resume warehouse
ALTER WAREHOUSE ANALYTICS_WH RESUME;

--changeset examples:resume-if-suspended-with-if-exists
-- Resume if suspended with IF EXISTS
ALTER WAREHOUSE IF EXISTS ANALYTICS_WH RESUME IF SUSPENDED;

<?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">

    <!-- Suspend warehouse -->
    <changeSet id="suspend-warehouse" author="examples">
        <pro-snowflake:alterWarehouseState
            warehouseName="ANALYTICS_WH"
            state="suspend"/>
    </changeSet>

    <!-- Resume warehouse -->
    <changeSet id="resume-warehouse" author="examples">
        <pro-snowflake:alterWarehouseState
            warehouseName="ANALYTICS_WH"
            state="resume"/>
    </changeSet>

    <!-- Resume if suspended (idempotent) -->
    <changeSet id="resume-if-suspended" author="examples">
        <pro-snowflake:alterWarehouseState
            warehouseName="ANALYTICS_WH"
            ifExists="true"
            state="resumeIfSuspended"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "suspend-warehouse",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseState": {
              "warehouseName": "ANALYTICS_WH",
              "state": "suspend"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "resume-warehouse",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseState": {
              "warehouseName": "ANALYTICS_WH",
              "state": "resume"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "resume-if-suspended",
        "author": "examples",
        "changes": [
          {
            "alterWarehouseState": {
              "warehouseName": "ANALYTICS_WH",
              "ifExists": true,
              "state": "resumeIfSuspended"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Suspend warehouse
  - changeSet:
      id: suspend-warehouse
      author: examples
      changes:
        - alterWarehouseState:
            warehouseName: ANALYTICS_WH
            state: suspend

  # Resume warehouse
  - changeSet:
      id: resume-warehouse
      author: examples
      changes:
        - alterWarehouseState:
            warehouseName: ANALYTICS_WH
            state: resume

  # Resume if suspended (idempotent)
  - changeSet:
      id: resume-if-suspended
      author: examples
      changes:
        - alterWarehouseState:
            warehouseName: ANALYTICS_WH
            ifExists: true
            state: resumeIfSuspended

--liquibase formatted sql

--changeset examples:suspend-warehouse
-- Suspend warehouse
ALTER WAREHOUSE ANALYTICS_WH SUSPEND;

--changeset examples:resume-warehouse
-- Resume warehouse
ALTER WAREHOUSE ANALYTICS_WH RESUME;

--changeset examples:resume-if-suspended-with-if-exists
-- Resume if suspended with IF EXISTS
ALTER WAREHOUSE IF EXISTS ANALYTICS_WH RESUME IF SUSPENDED;

alterWarehouseState

Available attributes

State values

XML

JSON

YAML

SQL