Transformation jobs

Transformation jobs include INSERT and MERGE jobs. Both allow you to insert and update the data in your table, MERGE jobs have the additional capability of deleting data if specified conditions are met.
When writing to a data lake table, if the ADD_MISSING_COLUMNS option is enabled, transformation jobs are also able to automatically infer the schema and populate the column names and types in the table.
When using jobs to write to tables, the table's underlying files are stored as Parquet.
Transformation jobs
​INSERT​
​MERGE​

System columns

INSERT

Last modified 1mo ago