Skip to main content

Celonis Product Documentation

Copying a table between data connections

You need to create or use a Transformation in a global Data Job (a Data Job without a Data Connection). In such a Transformation you can copy a table from one Data Connection to another using SQL, e.g.

Important

A common problem with long running transformations and slow data model loads is due to missing statistics in Vertica. This issue can be resolved by adding the Vertica ANALYZE_STATISTICS statement directly in the SQL. For more information, refer to Vertica Transformations Optimization.

CREATE TABLE <%= DataConnectionNameTarget %>.TableName AS SELECT * FROM <%= DataConnectionNameSource %>.TableName

The parameters used for the Cata Connection are supplied in all Transformations of global Data Jobs.

Copying from/to the global scope

You can also copy a table from the global Data Pool scope to a Data Connection scope or the other way around by simply omitting the Data Connection parameter.