Module mz_fivetran_destination::destination::dml
source · Structs
- Metadata about a column that is relevant to operations peformed by the destination.
Enums
Functions
- Copies a CSV file into a temporary table using the
COPY FROMprotocol. - “Soft deletes” rows by setting the
FIVETRAN_SYSTEM_COLUMN_SYNCEDtotrue, based on all primary keys. - Gets the existing “scratch” table that we can copy data into, or creates one if it doesn’t exist.
DELETEand thenINSERTfor all of the records inreplace_filesbased on primary key.- For each record in all
update_files,UPDATEall columns that are not the “unmodified string” to their new values provided in the record, based on primary key columns.