Secure 5.2.1: renameStage

renameStage

Last updated: July 13, 2026

Renames an existing stage in Snowflake.

Note: Automatic rollback renames the stage back to original name.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the stage	No
`schemaName`	String	Name of the schema containing the stage	No
`oldStageName`	String	Current name of the stage	Yes
`newStageName`	String	New name for the stage	Yes
`ifExists`	Boolean	Don't error if the stage doesn't exist	No

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

    <!-- Rename stage -->
    <changeSet id="rename-stage" author="examples">
        <pro-snowflake:renameStage
                oldStageName="OLD_STAGE"
                newStageName="NEW_STAGE"/>
    </changeSet>

    <!-- Rename stage with IF EXISTS -->
    <changeSet id="rename-stage-if-exists" author="examples">
        <pro-snowflake:renameStage
                oldStageName="TEMP_STAGE"
                newStageName="PERMANENT_STAGE"
                ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-stage",
        "author": "examples",
        "changes": [
          {
            "renameStage": {
              "oldStageName": "OLD_STAGE",
              "newStageName": "NEW_STAGE"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-stage-if-exists",
        "author": "examples",
        "changes": [
          {
            "renameStage": {
              "oldStageName": "TEMP_STAGE",
              "newStageName": "PERMANENT_STAGE",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Rename stage
  - changeSet:
      id: rename-stage
      author: examples
      changes:
        - renameStage:
            oldStageName: OLD_STAGE
            newStageName: NEW_STAGE

  # Rename stage with IF EXISTS
  - changeSet:
      id: rename-stage-if-exists
      author: examples
      changes:
        - renameStage:
            oldStageName: TEMP_STAGE
            newStageName: PERMANENT_STAGE
            ifExists: true

--liquibase formatted sql

--changeset examples:rename-stage
-- Rename stage
ALTER STAGE PUBLIC.OLD_STAGE RENAME TO PUBLIC.NEW_STAGE;

--changeset examples:rename-stage-with-if-exists
-- Rename stage with IF EXISTS
ALTER STAGE IF EXISTS PUBLIC.TEMP_STAGE RENAME TO PUBLIC.PERMANENT_STAGE;

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

    <!-- Rename stage -->
    <changeSet id="rename-stage" author="examples">
        <pro-snowflake:renameStage
                oldStageName="OLD_STAGE"
                newStageName="NEW_STAGE"/>
    </changeSet>

    <!-- Rename stage with IF EXISTS -->
    <changeSet id="rename-stage-if-exists" author="examples">
        <pro-snowflake:renameStage
                oldStageName="TEMP_STAGE"
                newStageName="PERMANENT_STAGE"
                ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-stage",
        "author": "examples",
        "changes": [
          {
            "renameStage": {
              "oldStageName": "OLD_STAGE",
              "newStageName": "NEW_STAGE"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-stage-if-exists",
        "author": "examples",
        "changes": [
          {
            "renameStage": {
              "oldStageName": "TEMP_STAGE",
              "newStageName": "PERMANENT_STAGE",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Rename stage
  - changeSet:
      id: rename-stage
      author: examples
      changes:
        - renameStage:
            oldStageName: OLD_STAGE
            newStageName: NEW_STAGE

  # Rename stage with IF EXISTS
  - changeSet:
      id: rename-stage-if-exists
      author: examples
      changes:
        - renameStage:
            oldStageName: TEMP_STAGE
            newStageName: PERMANENT_STAGE
            ifExists: true

--liquibase formatted sql

--changeset examples:rename-stage
-- Rename stage
ALTER STAGE PUBLIC.OLD_STAGE RENAME TO PUBLIC.NEW_STAGE;

--changeset examples:rename-stage-with-if-exists
-- Rename stage with IF EXISTS
ALTER STAGE IF EXISTS PUBLIC.TEMP_STAGE RENAME TO PUBLIC.PERMANENT_STAGE;

renameStage

Available attributes

XML

JSON

YAML

SQL

More like this