Secure 5.2.2: cloneTable

Reference
Version · 5.2.2
Reference guide

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;

PreviouscloneSchema NextcolumnStandardTable

Available attributes

timeTravelClause nested attributes

XML

JSON

YAML

SQL

More like this