Write Mode

Write modes define the way the data is being written into a database, as such they are available only for data warehouses.

You can choose from four available write modes when creating your data flow:

• Insert
• Insert Ignore
• Truncate Insert
• Upsert

INSERT

Insert is the default write mode which inserts new data and appends it to the pre-existing data in the destination. If data is extracted improperly, there is a high chance of data duplicates.

Example

INSERT IGNORE

New data will be inserted while ignoring error messages. This means that if a wrong data type is used in a record, that record is omitted. This write mode is used rarely.

Example

The data type for the "Amount" column is integer or float. However, there is a field with "Hello Gabi" which means that its data type is string or character. When insert_ignore is used, this row will be omitted when writing into the database.

TRUNCATE INSERT

Truncate_insert removes all previously existing content in the table before inserting newly extracted data.

UPSERT

Upsert inserts new rows and updates existing ones. You will have to set at least one unique key, which will represent one or multiple columns.

The primary key is a unique attribute that can never repeat and identifies entities in a table.

Before data is inserted, Dataddo checks the data in the destination. If data with the same primary key already exists in the table, the table is updated with the latest records, otherwise a new record is inserted. The advantage of upsert is avoiding duplicities.

Example

When extracting Facebook Post records, the primary key is "Post ID". If an ID has not been inserted before, a new record will be created. If there is already a record with the same ID, existing information will be updated.

Another example can be a phone number as there can't be two people with the same number.