The RevRec Canvas
Book B: Automating Snowflake and Alteryx with AI cover

Home › Build kit

Book B · Alteryx workflows for SAP RAR

Automating Snowflake and Alteryx with AI

Let an AI assistant write the Snowflake SQL, then prove it: a specification first, a review against it, data tests in Snowflake, an independent recomputation in Alteryx, and an unattended run that publishes the result only when every test passes.

  • Build kit
  • Intermediate
  • 67 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

An AI-written Snowflake view that runs cleanly and is wrong in four ways, found by a review, data tests and an independent Alteryx recomputation compared cell by cell, and a scheduled run that publishes only when every test passes.

What you get

  • The ebook: a 67-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (B_Revenue_Check.yxmd, Bb_Case_Check.yxmd)
  • Synthetic sample data (8 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 1The assistant writes it, you prove it
  2. Chapter 2The data and the Snowflake setup
  3. Chapter 3The one-line request
  4. Chapter 4Reviewing the draft
  5. Chapter 5Specification first
  6. Chapter 6Tests in Snowflake
  7. Chapter 7The independent check in Alteryx
  8. Chapter 8Comparing every cell, and the tests
  9. Chapter 9Running it unattended, and moving it to your system
  10. Chapter 10Golden cases: a test for every rule
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book B: Automating Snowflake and Alteryx with AI table of contents
Contents
Book B: Automating Snowflake and Alteryx with AI first page
First page