Skip to content

Schema Copy

Copy data from one or more tables from one schema to another. The source schema defaults to the one defined in the currently selected environment. Target tables can be new or existing, and can be appended to or replaced.

Warning

This component is potentially destructive. It may drop and recreate a target table marked as "replace" without warning.

You should consider running schema copy inside a transaction to ensure all changes are visible in the target schema, or none of them are. Use the Begin/Commit/Rollback components to do this.

Properties

Name = string

A human-readable name for the component.

Source Schema = drop-down

Select the source schema to copy from. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.

Target Schema = drop-down

The target schema to copy to. It may be a good idea to define a variable for the target schema so the value can be changed dynamically depending upon the environment the job is run in.

Tables to Copy = column editor

  • Table Name: An existing table from the Matillion ETL environment's source schema.
  • Copy Method:
    • Replace: Replace any like-named table in the target schema.
    • Append: Appends records to the target table. If the target table does not exist, it is created. If the target table does exists, its structure must be identical to the source table.
Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics
❌ ❌ ✅ ❌ ❌