Adverity Explore - Overwrite Options

Settings:

• Key Columns: 
  Can be defined in Schema Mapping and are equally treated with other options. This is very process intense, and so we advise you avoid using it unless absolutely necessary. [Default=Disabled]
• Datastream:
  Will delete all rows from particular Datastream. Adverity Insights determines this by looking at the Datatap Endpoint. [Default=Enabled]
• Filename:
  Uses current filename and deletes all rows holding the same, e.g. gsc-104-20180708-64ecec6ab9c94a29bd72b24deeb1bfd0.csv. [Default=Disabled]
• Date Range:
  Uses the column mapped to 'day' to determine date range to overwrite. [Default=Enabled]

Common Use Cases:

1. Datastream + Date Range:
   Delete data from same Datastream within same date range. 
2. Datastream: 
   Can be used whenever ALL old extracts from same Datastream should be deleted.

Import Speed:

Setting key columns to import to Adverity Explore should only be used if absolutely necessary, as they require additional import time and resources. See below for the fastest import options: 

1. Datastream + date range
2. Datastream
3. Filename
4. Datastream + date range + key columns
5. Datastream + key columns