What are Workbooks?

A workbook represents a spreadsheet style view representing a single execution of a project with specific source data. When you create a new project and upload source data, Lume will start an initial run:

  1. Generate descriptions over the source data if none are provided
  2. Create mapping logic
  3. Validate the transformation
  4. Process your initial source data

A workbook contains model level metadat such as the status of the target model, number of mapped fields, test results, and current tracking of fields that have been reviewd.

Components of the Workbook

  1. Target Field - The name of the field
  2. Source Table - The source tables that were used to transform to the target field
  3. Source Field - The source fields that were used to transform to the target field
  4. Type - The type of the target field
  5. Nullable - If the field can be nullable or not
  6. Description - The description of the target field
  7. Current Transform - The set of actions taken to transform the source data into the target field
  8. Review Status - The user review status of the workbook

Workbook Review Status

A workbook has a review status to track the fields that have been manually checked. By default, the status will be NOT_REVIEWED.

StatusDescription
NOT_REVIEWEDThe field has not been confirmed
FLAGGEDThe field has been flagged to investigate deeper
USER_APPROVEDThe user provides a set of actions for the AI to take
AI_APPROVEDThe user approves the set of actions that the AI took to transform the data

Target Model Statuses

Each model can have one of the following statuses:

StatusDescription
successThe run completed successfully
errorThe run encountered errors during processing
skippedThe run was skipped due to an upstream dependency issue
partial successThe run completed with partial success
no opThe run had no action taken

Test Statuses

Each test for a field can have one of the following statuses:

StatusDescription
passThe test completed successfully
errorThe test encountered errors
failThe test failed the validation
warnThe run completed with partial success
skippedThe test was skipped due to an upstream dependency issue

If a run fails, crashes, or is incomplete, please contact support.