Snowflake renameView

Last updated: March 26, 2026

Renames an existing Snowflake view, with support for cross-schema and cross-database moves.

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

Known limitations:

Snowflake snapshots created with Liquibase Secure 5.1 are incompatible with earlier versions due to enhanced object type detection for TABLES and VIEWS. Regenerate all snapshots with 5.1 after upgrading to avoid false differences in diff and diff-changelog operations.
The Liquibase renameView change type is not compatible for Snowflake users in Liquibase Secure 5.1 using YAML or JSON change type formats. This does not affect XML change types at all. If you’re connecting to a Snowflake database, Liquibase automatically detects that you are using the Snowflake renameView change type and breaks backwards compatibility with the Liquibase renameView change type. We recommend upgrading to Liquibase Secure 5.1.1 to use createView with YAML and JSON change type formats successfully.

Available attributes

Attribute	Type	Description	Required
`oldCatalogName`	String	Name of the database containing the view to rename	No
`oldSchemaName`	String	Name of the schema containing the view to rename	No
`oldViewName`	String	Current name of the view	Yes
`newCatalogName`	String	Target database name (for cross-database rename)	No
`newSchemaName`	String	Target schema name (for cross-schema rename)	No
`newViewName`	String	New name for the view	Yes
`ifExists`	Boolean	If true, do not throw an error if the view doesn't exist	No

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

    <!-- Simple rename within current schema -->
    <changeSet id="simple-rename" author="examples">
        <pro-snowflake:renameView
            oldViewName="OLD_VIEW"
            newViewName="NEW_VIEW"/>
    </changeSet>

    <!-- Rename with explicit schema -->
    <changeSet id="rename-with-schema" author="examples">
        <pro-snowflake:renameView
            oldSchemaName="PUBLIC"
            oldViewName="OLD_VIEW"
            newSchemaName="PUBLIC"
            newViewName="NEW_VIEW"/>
    </changeSet>

    <!-- Cross-schema rename (move view to different schema) -->
    <changeSet id="cross-schema-rename" author="examples">
        <pro-snowflake:renameView
            oldSchemaName="DEV_SCHEMA"
            oldViewName="ANALYTICS_VIEW"
            newSchemaName="PROD_SCHEMA"
            newViewName="ANALYTICS_VIEW"/>
    </changeSet>

    <!-- Cross-database rename -->
    <changeSet id="cross-database-rename" author="examples">
        <pro-snowflake:renameView
            oldCatalogName="DEV_DB"
            oldSchemaName="PUBLIC"
            oldViewName="REPORT_VIEW"
            newCatalogName="PROD_DB"
            newSchemaName="PUBLIC"
            newViewName="REPORT_VIEW"/>
    </changeSet>

    <!-- Rename with IF EXISTS -->
    <changeSet id="rename-if-exists" author="examples">
        <pro-snowflake:renameView
            oldViewName="OLD_VIEW"
            newViewName="NEW_VIEW"
            ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "simple-rename",
        "author": "examples",
        "changes": [
          {
            "renameView": {
              "oldViewName": "OLD_VIEW",
              "newViewName": "NEW_VIEW"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "cross-schema-rename",
        "author": "examples",
        "changes": [
          {
            "renameView": {
              "oldSchemaName": "DEV_SCHEMA",
              "oldViewName": "ANALYTICS_VIEW",
              "newSchemaName": "PROD_SCHEMA",
              "newViewName": "ANALYTICS_VIEW"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "cross-database-rename",
        "author": "examples",
        "changes": [
          {
            "renameView": {
              "oldCatalogName": "DEV_DB",
              "oldSchemaName": "PUBLIC",
              "oldViewName": "REPORT_VIEW",
              "newCatalogName": "PROD_DB",
              "newSchemaName": "PUBLIC",
              "newViewName": "REPORT_VIEW"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Simple rename within current schema
  - changeSet:
      id: simple-rename
      author: examples
      changes:
        - renameView:
            oldViewName: OLD_VIEW
            newViewName: NEW_VIEW

  #Rename with explicit schema
  - changeSet:
      id: rename-with-schema
      author: examples
      changes:
        - renameView:
            oldSchemaName: PUBLIC
            oldViewName: OLD_VIEW
            newSchemaName: PUBLIC
            newViewName: NEW_VIEW

  #Cross-schema rename
  - changeSet:
      id: cross-schema-rename
      author: examples
      changes:
        - renameView:
            oldSchemaName: DEV_SCHEMA
            oldViewName: ANALYTICS_VIEW
            newSchemaName: PROD_SCHEMA
            newViewName: ANALYTICS_VIEW

  #Rename with IF EXISTS
  - changeSet:
      id: rename-if-exists
      author: examples
      changes:
        - renameView:
            oldViewName: OLD_VIEW
            newViewName: NEW_VIEW
            ifExists: true

--liquibase formatted sql

--changeset examples:simple-rename
-- Simple rename
ALTER VIEW OLD_VIEW RENAME TO NEW_VIEW;

--changeset examples:rename-with-schema
-- Rename with schema
ALTER VIEW PUBLIC.OLD_VIEW RENAME TO PUBLIC.NEW_VIEW;

--changeset examples:cross-schema-rename
-- Cross-schema rename
ALTER VIEW DEV_SCHEMA.ANALYTICS_VIEW RENAME TO PROD_SCHEMA.ANALYTICS_VIEW;

--changeset examples:cross-database-rename
-- Cross-database rename
ALTER VIEW DEV_DB.PUBLIC.REPORT_VIEW RENAME TO PROD_DB.PUBLIC.REPORT_VIEW;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER VIEW IF EXISTS OLD_VIEW RENAME TO NEW_VIEW;

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

    <!-- Simple rename within current schema -->
    <changeSet id="simple-rename" author="examples">
        <pro-snowflake:renameView
            oldViewName="OLD_VIEW"
            newViewName="NEW_VIEW"/>
    </changeSet>

    <!-- Rename with explicit schema -->
    <changeSet id="rename-with-schema" author="examples">
        <pro-snowflake:renameView
            oldSchemaName="PUBLIC"
            oldViewName="OLD_VIEW"
            newSchemaName="PUBLIC"
            newViewName="NEW_VIEW"/>
    </changeSet>

    <!-- Cross-schema rename (move view to different schema) -->
    <changeSet id="cross-schema-rename" author="examples">
        <pro-snowflake:renameView
            oldSchemaName="DEV_SCHEMA"
            oldViewName="ANALYTICS_VIEW"
            newSchemaName="PROD_SCHEMA"
            newViewName="ANALYTICS_VIEW"/>
    </changeSet>

    <!-- Cross-database rename -->
    <changeSet id="cross-database-rename" author="examples">
        <pro-snowflake:renameView
            oldCatalogName="DEV_DB"
            oldSchemaName="PUBLIC"
            oldViewName="REPORT_VIEW"
            newCatalogName="PROD_DB"
            newSchemaName="PUBLIC"
            newViewName="REPORT_VIEW"/>
    </changeSet>

    <!-- Rename with IF EXISTS -->
    <changeSet id="rename-if-exists" author="examples">
        <pro-snowflake:renameView
            oldViewName="OLD_VIEW"
            newViewName="NEW_VIEW"
            ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "simple-rename",
        "author": "examples",
        "changes": [
          {
            "renameView": {
              "oldViewName": "OLD_VIEW",
              "newViewName": "NEW_VIEW"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "cross-schema-rename",
        "author": "examples",
        "changes": [
          {
            "renameView": {
              "oldSchemaName": "DEV_SCHEMA",
              "oldViewName": "ANALYTICS_VIEW",
              "newSchemaName": "PROD_SCHEMA",
              "newViewName": "ANALYTICS_VIEW"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "cross-database-rename",
        "author": "examples",
        "changes": [
          {
            "renameView": {
              "oldCatalogName": "DEV_DB",
              "oldSchemaName": "PUBLIC",
              "oldViewName": "REPORT_VIEW",
              "newCatalogName": "PROD_DB",
              "newSchemaName": "PUBLIC",
              "newViewName": "REPORT_VIEW"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Simple rename within current schema
  - changeSet:
      id: simple-rename
      author: examples
      changes:
        - renameView:
            oldViewName: OLD_VIEW
            newViewName: NEW_VIEW

  #Rename with explicit schema
  - changeSet:
      id: rename-with-schema
      author: examples
      changes:
        - renameView:
            oldSchemaName: PUBLIC
            oldViewName: OLD_VIEW
            newSchemaName: PUBLIC
            newViewName: NEW_VIEW

  #Cross-schema rename
  - changeSet:
      id: cross-schema-rename
      author: examples
      changes:
        - renameView:
            oldSchemaName: DEV_SCHEMA
            oldViewName: ANALYTICS_VIEW
            newSchemaName: PROD_SCHEMA
            newViewName: ANALYTICS_VIEW

  #Rename with IF EXISTS
  - changeSet:
      id: rename-if-exists
      author: examples
      changes:
        - renameView:
            oldViewName: OLD_VIEW
            newViewName: NEW_VIEW
            ifExists: true

--liquibase formatted sql

--changeset examples:simple-rename
-- Simple rename
ALTER VIEW OLD_VIEW RENAME TO NEW_VIEW;

--changeset examples:rename-with-schema
-- Rename with schema
ALTER VIEW PUBLIC.OLD_VIEW RENAME TO PUBLIC.NEW_VIEW;

--changeset examples:cross-schema-rename
-- Cross-schema rename
ALTER VIEW DEV_SCHEMA.ANALYTICS_VIEW RENAME TO PROD_SCHEMA.ANALYTICS_VIEW;

--changeset examples:cross-database-rename
-- Cross-database rename
ALTER VIEW DEV_DB.PUBLIC.REPORT_VIEW RENAME TO PROD_DB.PUBLIC.REPORT_VIEW;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER VIEW IF EXISTS OLD_VIEW RENAME TO NEW_VIEW;

Snowflake renameView

Available attributes

XML example

JSON example

YAML example

SQL example

More like this