Data transformation

Upsolver has hundreds of built-in functions and operators. Click here to see a full list of functions and operators.
Transformation jobs include INSERT and MERGE jobs which allow you to insert and merge your data respectively from a chosen 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 type