cloneTable

Last updated: January 27, 2026

Creates a zero-copy clone of a Snowflake standard table with optional time travel support. Clones can be created from the current state or from a specific point in time within the retention window.

Known limitation: 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.

Available attributes

Attribute	Type	Description	Required
`sourceCatalogName`	String	Name of the catalog containing the source table	No
`sourceSchemaName`	String	Name of the schema containing the source table	No
`sourceTableName`	String	Name of the table to clone from	Yes
`targetCatalogName`	String	Name of the catalog for the cloned table	No
`targetSchemaName`	String	Name of the schema for the cloned table	No
`targetTableName`	String	Name of the new cloned table	Yes
`replaceIfExists`	Boolean	If true, replaces existing table with `OR REPLACE`*	No
`ifNotExists`	Boolean	If true, only creates if target doesn't exist*	No
`copyGrants`	Boolean	If true, copies grants from source table**	No
`temporary`	Boolean	If true, creates a `TEMPORARY` table (session-scoped)***	No
`isTransient`	Boolean	If true, creates a `TRANSIENT` table (no fail-safe)***	No
`timeTravelClause`	Nested	Time travel options for cloning from historical state	No

*replaceIfExists and ifNotExists are mutually exclusive.

**copyGrants requires replaceIfExists=true.

***temporary and isTransient are mutually exclusive.

timeTravelClause nested attributes

Attribute	Type	Description	Required
`timeTravelType`	String	Either `AT` or `BEFORE`	Yes
`timestamp`	String	Absolute timestamp or SQL expression****	No
`offset`	String	Relative seconds (e.g., `-3600` for 1 hour ago)****	No
`statement`	String	Statement ID from query history****	No

****Exactly one of timestamp, offset, or statement must be specified.

<?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 clone - current state -->
    <changeSet id="clone-simple" author="examples">
        <pro-snowflake:cloneTable
            sourceTableName="source_table"
            targetTableName="cloned_table_simple"/>
    </changeSet>

    <!-- Clone with time travel OFFSET and TEMPORARY -->
    <changeSet id="clone-with-offset" author="examples">
        <pro-snowflake:cloneTable
            sourceTableName="source_table"
            targetTableName="cloned_table_offset"
            ifNotExists="true"
            temporary="true">
            <pro-snowflake:timeTravelClause timeTravelType="BEFORE">
                <pro-snowflake:offset>-300</pro-snowflake:offset>
            </pro-snowflake:timeTravelClause>
        </pro-snowflake:cloneTable>
    </changeSet>

    <!-- Clone with time travel TIMESTAMP -->
    <changeSet id="clone-with-timestamp" author="examples">
        <pro-snowflake:cloneTable
            sourceTableName="source_table"
            targetTableName="cloned_table_timestamp">
            <pro-snowflake:timeTravelClause timeTravelType="AT">
                <pro-snowflake:timestamp>2025-01-15 09:30:00</pro-snowflake:timestamp>
            </pro-snowflake:timeTravelClause>
        </pro-snowflake:cloneTable>
    </changeSet>

    <!-- Clone with OR REPLACE, COPY GRANTS, and TRANSIENT -->
    <changeSet id="clone-full-featured" author="examples">
        <pro-snowflake:cloneTable
            sourceTableName="source_table"
            targetTableName="cloned_table_full"
            replaceIfExists="true"
            copyGrants="true"
            isTransient="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "clone-simple",
        "author": "examples",
        "changes": [
          {
            "cloneTable": {
              "sourceTableName": "source_table",
              "targetTableName": "cloned_table_simple"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "clone-with-offset",
        "author": "examples",
        "changes": [
          {
            "cloneTable": {
              "sourceTableName": "source_table",
              "targetTableName": "cloned_table_offset",
              "ifNotExists": true,
              "temporary": true,
              "timeTravelClause": {
                "timeTravelType": "BEFORE",
                "offset": "-300"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "clone-with-timestamp",
        "author": "examples",
        "changes": [
          {
            "cloneTable": {
              "sourceTableName": "source_table",
              "targetTableName": "cloned_table_timestamp",
              "timeTravelClause": {
                "timeTravelType": "AT",
                "timestamp": "2025-01-15 09:30:00"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "clone-full-featured",
        "author": "examples",
        "changes": [
          {
            "cloneTable": {
              "sourceTableName": "source_table",
              "targetTableName": "cloned_table_full",
              "replaceIfExists": true,
              "copyGrants": true,
              "isTransient": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Simple clone - current state
  - changeSet:
      id: clone-simple
      author: examples
      changes:
        - cloneTable:
            sourceTableName: source_table
            targetTableName: cloned_table_simple

  #Clone with time travel OFFSET and TEMPORARY
  - changeSet:
      id: clone-with-offset
      author: examples
      changes:
        - cloneTable:
            sourceTableName: source_table
            targetTableName: cloned_table_offset
            ifNotExists: true
            temporary: true
            timeTravelClause:
              timeTravelType: BEFORE
              offset: "-300"

  #Clone with time travel TIMESTAMP
  - changeSet:
      id: clone-with-timestamp
      author: examples
      changes:
        - cloneTable:
            sourceTableName: source_table
            targetTableName: cloned_table_timestamp
            timeTravelClause:
              timeTravelType: AT
              timestamp: "2025-01-15 09:30:00"

  #Clone with OR REPLACE, COPY GRANTS, and TRANSIENT
  - changeSet:
      id: clone-full-featured
      author: examples
      changes:
        - cloneTable:
            sourceTableName: source_table
            targetTableName: cloned_table_full
            replaceIfExists: true
            copyGrants: true
            isTransient: true

--liquibase formatted sql

--changeset examples:simple-clone
-- Simple clone
CREATE TABLE MYDB.PUBLIC.cloned_table_simple CLONE MYDB.PUBLIC.source_table;

--changeset examples:clone-with-time-travel-offset-and-temporary
-- Clone with time travel OFFSET and TEMPORARY
CREATE TEMP TABLE IF NOT EXISTS MYDB.PUBLIC.cloned_table_offset CLONE MYDB.PUBLIC.source_table
    BEFORE (OFFSET => -300);

--changeset examples:clone-with-time-travel-timestamp
-- Clone with time travel TIMESTAMP
CREATE TABLE MYDB.PUBLIC.cloned_table_timestamp CLONE MYDB.PUBLIC.source_table
    AT (TIMESTAMP => '2025-01-15 09:30:00');

--changeset examples:clone-with-or-replace-copy-grants-and-transient
-- Clone with OR REPLACE, COPY GRANTS, and TRANSIENT
CREATE OR REPLACE TRANSIENT TABLE MYDB.PUBLIC.cloned_table_full CLONE MYDB.PUBLIC.source_table
    COPY GRANTS;

<?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 clone - current state -->
    <changeSet id="clone-simple" author="examples">
        <pro-snowflake:cloneTable
            sourceTableName="source_table"
            targetTableName="cloned_table_simple"/>
    </changeSet>

    <!-- Clone with time travel OFFSET and TEMPORARY -->
    <changeSet id="clone-with-offset" author="examples">
        <pro-snowflake:cloneTable
            sourceTableName="source_table"
            targetTableName="cloned_table_offset"
            ifNotExists="true"
            temporary="true">
            <pro-snowflake:timeTravelClause timeTravelType="BEFORE">
                <pro-snowflake:offset>-300</pro-snowflake:offset>
            </pro-snowflake:timeTravelClause>
        </pro-snowflake:cloneTable>
    </changeSet>

    <!-- Clone with time travel TIMESTAMP -->
    <changeSet id="clone-with-timestamp" author="examples">
        <pro-snowflake:cloneTable
            sourceTableName="source_table"
            targetTableName="cloned_table_timestamp">
            <pro-snowflake:timeTravelClause timeTravelType="AT">
                <pro-snowflake:timestamp>2025-01-15 09:30:00</pro-snowflake:timestamp>
            </pro-snowflake:timeTravelClause>
        </pro-snowflake:cloneTable>
    </changeSet>

    <!-- Clone with OR REPLACE, COPY GRANTS, and TRANSIENT -->
    <changeSet id="clone-full-featured" author="examples">
        <pro-snowflake:cloneTable
            sourceTableName="source_table"
            targetTableName="cloned_table_full"
            replaceIfExists="true"
            copyGrants="true"
            isTransient="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "clone-simple",
        "author": "examples",
        "changes": [
          {
            "cloneTable": {
              "sourceTableName": "source_table",
              "targetTableName": "cloned_table_simple"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "clone-with-offset",
        "author": "examples",
        "changes": [
          {
            "cloneTable": {
              "sourceTableName": "source_table",
              "targetTableName": "cloned_table_offset",
              "ifNotExists": true,
              "temporary": true,
              "timeTravelClause": {
                "timeTravelType": "BEFORE",
                "offset": "-300"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "clone-with-timestamp",
        "author": "examples",
        "changes": [
          {
            "cloneTable": {
              "sourceTableName": "source_table",
              "targetTableName": "cloned_table_timestamp",
              "timeTravelClause": {
                "timeTravelType": "AT",
                "timestamp": "2025-01-15 09:30:00"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "clone-full-featured",
        "author": "examples",
        "changes": [
          {
            "cloneTable": {
              "sourceTableName": "source_table",
              "targetTableName": "cloned_table_full",
              "replaceIfExists": true,
              "copyGrants": true,
              "isTransient": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Simple clone - current state
  - changeSet:
      id: clone-simple
      author: examples
      changes:
        - cloneTable:
            sourceTableName: source_table
            targetTableName: cloned_table_simple

  #Clone with time travel OFFSET and TEMPORARY
  - changeSet:
      id: clone-with-offset
      author: examples
      changes:
        - cloneTable:
            sourceTableName: source_table
            targetTableName: cloned_table_offset
            ifNotExists: true
            temporary: true
            timeTravelClause:
              timeTravelType: BEFORE
              offset: "-300"

  #Clone with time travel TIMESTAMP
  - changeSet:
      id: clone-with-timestamp
      author: examples
      changes:
        - cloneTable:
            sourceTableName: source_table
            targetTableName: cloned_table_timestamp
            timeTravelClause:
              timeTravelType: AT
              timestamp: "2025-01-15 09:30:00"

  #Clone with OR REPLACE, COPY GRANTS, and TRANSIENT
  - changeSet:
      id: clone-full-featured
      author: examples
      changes:
        - cloneTable:
            sourceTableName: source_table
            targetTableName: cloned_table_full
            replaceIfExists: true
            copyGrants: true
            isTransient: true

--liquibase formatted sql

--changeset examples:simple-clone
-- Simple clone
CREATE TABLE MYDB.PUBLIC.cloned_table_simple CLONE MYDB.PUBLIC.source_table;

--changeset examples:clone-with-time-travel-offset-and-temporary
-- Clone with time travel OFFSET and TEMPORARY
CREATE TEMP TABLE IF NOT EXISTS MYDB.PUBLIC.cloned_table_offset CLONE MYDB.PUBLIC.source_table
    BEFORE (OFFSET => -300);

--changeset examples:clone-with-time-travel-timestamp
-- Clone with time travel TIMESTAMP
CREATE TABLE MYDB.PUBLIC.cloned_table_timestamp CLONE MYDB.PUBLIC.source_table
    AT (TIMESTAMP => '2025-01-15 09:30:00');

--changeset examples:clone-with-or-replace-copy-grants-and-transient
-- Clone with OR REPLACE, COPY GRANTS, and TRANSIENT
CREATE OR REPLACE TRANSIENT TABLE MYDB.PUBLIC.cloned_table_full CLONE MYDB.PUBLIC.source_table
    COPY GRANTS;

cloneTable

Available attributes

timeTravelClause nested attributes

XML

JSON

YAML

SQL

More like this