An upstream source writes Parquet data as hourly batches to directories named with the current...

Each write to the orders table will only contain unique records, and only those records without duplicates in the target table will be written.

Each write to the orders table will only contain unique records, but newly written records may have duplicates already present in the target table.

Each write to the orders table will only contain unique records; if existing records with the same key are present in the target table, these records will be overwritten.

Each write to the orders table will only contain unique records; if existing records with the same key are present in the target table, the operation will tail.

Each write to the orders table will run deduplication over the union of new and existing records, ensuring no duplicate records are present.