Transformation jobs include INSERT and MERGE jobs. Both enable you to insert and update the data in your table, and MERGE jobs can delete 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.


Job Options