Process Overview

May 21, 2019
|By Thomas Pryce

Search Knowledge Base by Keyword

Created OnMay 21, 2019
byThomas Pryce
< Back

Once you have updated your Control Spreadsheet, you can run the actions involved in an Advanced Subset.

The Actions typically involved in running an iterative Subset are:

  1. DROP: Drops the tables registered by the TABLES action and deletes the data in your Target Database. You will only run this if something has gone wrong in a Subset, and you want to create a wholly new Data Subset.
    1. PREPENV: If you drop the tables, you will need to re-register tables before performing the next Subset.
  2. TRUNCATE: Deletes data from the Target Database or Schema.
  3. BUILDMODEL: Creates the rules to drive the Advanced Subset, based on the Control Spreadsheet.
  4. SUBSET: Writes the new Data Subset to the Staging Database.