Transformation
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.
Syntax
Job Options
Last updated