Skip to main content
Schema Copy is an orchestration component that lets you 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.
This component is potentially destructive. It may drop and recreate a target table marked as “replace” without warning.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
Source Schema
drop-down
required
Select the source schema to copy from. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, read Schemas.
​
Target Schema
drop-down
required
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 pipeline is run in.
​
Tables to Copy
column editor
required
  • Table Name: An existing table from 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.
Click the Text mode toggle at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, select the Use Grid Variable checkbox at the bottom of the dialog. For more information, read Grid variables.