Data transformation
This section describes how to ingest data into your target system using SQL to create jobs.
Upsolver includes hundreds of built-in functions and operators. Take a look at the reference guide to see how you can customize your jobs.
Transformation jobs include INSERT
and MERGE
statements, enabling you to insert and merge your data respectively to a target destination.
Just like ingestion jobs, these jobs can automatically infer the schema and populate the column names and types in the target table, provided that the ADD_MISSING_COLUMNS
option is enabled.
Learn more about writing to each target location
Last updated