alterDynamicTable renameTo

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>