Extract load methods
Drop, create, load. Truncate, load and Append? Explained...
The load methods is in relation to the way the data is loaded into the destination table.
- Drop, create, load This will delete the destination table, recreate the table, then load in the new data.
- Truncate, load This will remove any old data from the table, then add in the new data, the column names and table schema will persist.
- Append This will add any new data to the bottom of the destination table, any old data will not be deleted. If incremental is supported, then it will be executed automatically, if the load method is set to append.
Updated 11 months ago