...
If the :destination
column already exists, the force
option can be set to true
to overwrite any existing data in that column. By default, the force
option is set to false
. For example, the following directive overwrites the values in col_b
with the values in col_a
:
Code Block |
---|
copy :col_a :col_b true |
Usage Notes
The COPY directive will copy data from :source
if :source
column exists. If the :source
doesn't exist in the record, the execution will fail with an error.
Copying makes a deep copy of the source into the destination. The type of data from the source in the destination column is maintained as-is.
To overwrite existing data, the source and destination column must have the compatible data types. For example, you cannot overwrite a column of type Double with a column of type String.
Example
Using this record as an example:
...