The RevRec Canvas
Book 42: Engineering a 1,000-tool workflow: Control Containers, Test tools, dynamic In-DB batching and schema guards cover

Home › Build kit

Book 42 · Alteryx workflows for SAP RAR

Engineering a 1,000-tool workflow: Control Containers, Test tools, dynamic In-DB batching and schema guards

Control Containers that run in a guaranteed order, a schema guard that checks Snowflake before any data is read, batches planned from the data and run through Dynamic Input In-DB, and Test tools that stop the run the moment something is wrong.

  • Build kit
  • Advanced
  • 93 pages
  • Tested workflows and sample data
$49Individual license · Team of five $147
Buy this bookTry the free Book 2 sample

What the example shows

A 101-tool workflow in seven Control Containers reads 2,242 postings from Snowflake in batches planned from the data. A schema guard, five Test-tool guards and an independent control prove nothing fell between the batches. Second workflow: a preliminary and a final run compared from their evidence files, with no Snowflake needed.

What you get

  • The ebook: a 93-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (42_Large_Workflow.yxmd, 42b_Run_Compare.yxmd)
  • 1 batch macro
  • Synthetic sample data (3 files) and an answer key, so you can check every number
  • Runs in Alteryx Designer 2023.1 or later; one zip, delivered by email right after payment

Contents

  1. Chapter 1Why big workflows break
  2. Chapter 2The data, Snowflake and the connection
  3. Chapter 3Stages that run in order
  4. Chapter 4Stage 01: the schema guard
  5. Chapter 5Stage 02: a batch plan made from the data
  6. Chapter 6Stage 03: extract in batches
  7. Chapter 7Stage 04: a control that does not trust the batches
  8. Chapter 8Stages 05 to 07: the report, and reading the result
  9. Chapter 9From a hundred tools to a thousand, and onto your
  10. Chapter 10Two runs side by side
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 42: Engineering a 1,000-tool workflow: Control Containers, Test tools, dynamic In-DB batching and schema guards table of contents
Contents
Book 42: Engineering a 1,000-tool workflow: Control Containers, Test tools, dynamic In-DB batching and schema guards first page
First page