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
​Output to an Amazon Athena table​
​Output to an Amazon Redshift table​
​Output to an Amazon S3 bucket​
​Output to an Elasticsearch index​
​Output to a Snowflake table​

Job configuration guide for CDC

Upsolver Case Sensitivity Approach

Last modified 1mo ago