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