~/talk

Effortless Low-Code Data Testing

Talkat SQLBits 2019 · 2019-02-27..03-02· [testing, data-engineering]
links:none on file
slides:none on file

Claims a low-code test harness that installs with one-line Install-Module cat, runs tests defined as SQL selects compared across sources, and plugs into CI/CD (Azure DevOps) with three PowerShell commands. Demonstrates cross-system checks between Postgres, SQL Server and Power BI, runs tens of thousands of rows in seconds, exports standardized results (JSON/JUnit) and offers a baby GUI in Microsoft Store. Asserts this prevents parts of the “billions of dollars wasted” on untrusted data.

AI-written summary · about

  1. 0:00Introduction
  2. 1:13Data quality cost
  3. 2:56Obstacles to testing
  4. 4:01Demo: Date dimension testing
  5. 8:39Demo: Cross-platform checks
  6. 11:30CAT simplifies testing
  7. 12:13CAT in CI/CD
  8. 13:34CAT use cases
  9. 15:40Contributing to CAT
  10. 16:23CAT scenarios
  11. 17:48Automating production checks
  12. 18:10Closing
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.