Alter Dynamic Table - Rename

alterDynamicTable renameTo

Last updated: January 27, 2026

Renames a dynamic table to a new name and optionally moves it to a different schema or catalog.

Known limitations:

This change type does not support automatic rollback.

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.Note: This change type does not support automatic rollback.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the table	No
`schemaName`	String	Name of the schema containing the table	No
`tableName`	String	Name of the dynamic table to alter	Yes
`ifExists`	Boolean	Only execute if the table exists	No

renameTo nested attributes

Attribute	Type	Description	Required
`newName`	String	New name for the dynamic table	Yes
`newCatalogName`	String	New catalog (database) name	No
`newSchemaName`	String	New schema name	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">

    <!-- Simple rename -->
    <changeSet id="rename-dynamic-table" author="examples">
        <pro-snowflake:alterDynamicTable tableName="OLD_SUMMARY_TABLE">
            <pro-snowflake:renameTo newName="NEW_SUMMARY_TABLE"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

    <!-- Move to different schema -->
    <changeSet id="move-to-schema" author="examples">
        <pro-snowflake:alterDynamicTable tableName="TEMP_SUMMARY">
            <pro-snowflake:renameTo
                newName="PRODUCTION_SUMMARY"
                newSchemaName="PROD_SCHEMA"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-dynamic-table",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "OLD_SUMMARY_TABLE",
              "renameTo": {
                "newName": "NEW_SUMMARY_TABLE"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "move-to-schema",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "TEMP_SUMMARY",
              "renameTo": {
                "newName": "PRODUCTION_SUMMARY",
                "newSchemaName": "PROD_SCHEMA"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Simple rename
  - changeSet:
      id: rename-dynamic-table
      author: examples
      changes:
        - alterDynamicTable:
            tableName: OLD_SUMMARY_TABLE
            renameTo:
              newName: NEW_SUMMARY_TABLE

  # Move to different schema
  - changeSet:
      id: move-to-schema
      author: examples
      changes:
        - alterDynamicTable:
            tableName: TEMP_SUMMARY
            renameTo:
              newName: PRODUCTION_SUMMARY
              newSchemaName: PROD_SCHEMA

--liquibase formatted sql

--changeset examples:simple-rename
-- Simple rename
ALTER DYNAMIC TABLE MYDB.PUBLIC.OLD_SUMMARY_TABLE RENAME TO NEW_SUMMARY_TABLE;

--changeset examples:move-to-different-schema
-- Move to different schema
ALTER DYNAMIC TABLE MYDB.PUBLIC.TEMP_SUMMARY RENAME TO PROD_SCHEMA.PRODUCTION_SUMMARY;

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

    <!-- Simple rename -->
    <changeSet id="rename-dynamic-table" author="examples">
        <pro-snowflake:alterDynamicTable tableName="OLD_SUMMARY_TABLE">
            <pro-snowflake:renameTo newName="NEW_SUMMARY_TABLE"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

    <!-- Move to different schema -->
    <changeSet id="move-to-schema" author="examples">
        <pro-snowflake:alterDynamicTable tableName="TEMP_SUMMARY">
            <pro-snowflake:renameTo
                newName="PRODUCTION_SUMMARY"
                newSchemaName="PROD_SCHEMA"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-dynamic-table",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "OLD_SUMMARY_TABLE",
              "renameTo": {
                "newName": "NEW_SUMMARY_TABLE"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "move-to-schema",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "TEMP_SUMMARY",
              "renameTo": {
                "newName": "PRODUCTION_SUMMARY",
                "newSchemaName": "PROD_SCHEMA"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Simple rename
  - changeSet:
      id: rename-dynamic-table
      author: examples
      changes:
        - alterDynamicTable:
            tableName: OLD_SUMMARY_TABLE
            renameTo:
              newName: NEW_SUMMARY_TABLE

  # Move to different schema
  - changeSet:
      id: move-to-schema
      author: examples
      changes:
        - alterDynamicTable:
            tableName: TEMP_SUMMARY
            renameTo:
              newName: PRODUCTION_SUMMARY
              newSchemaName: PROD_SCHEMA

--liquibase formatted sql

--changeset examples:simple-rename
-- Simple rename
ALTER DYNAMIC TABLE MYDB.PUBLIC.OLD_SUMMARY_TABLE RENAME TO NEW_SUMMARY_TABLE;

--changeset examples:move-to-different-schema
-- Move to different schema
ALTER DYNAMIC TABLE MYDB.PUBLIC.TEMP_SUMMARY RENAME TO PROD_SCHEMA.PRODUCTION_SUMMARY;

alterDynamicTable renameTo

Available attributes

renameTo nested attributes

XML

JSON

YAML

SQL

More like this