Effortless Low-Code Data Testing
summary
Claims a low-code test harness called cat that runs SQL/Power BI checks with three commands and plugs into CI/CD. Example tests: a date-dimension end-date mismatch is caught automatically, and a cross-system reconciliation (Postgres -> SQL Server -> Power BI) compares grouped flight counts across tens of thousands of rows and reports equality or missing dates. Setup uses Install-Module cat, Import-Module cat and Invoke-CatProject, publishes results to Azure DevOps, and offers a Community Preview UI (CAT Studio).
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:13Data quality cost
- 2:56Obstacles to testing
- 4:01Demo: Date dimension testing
- 8:39Demo: Cross-platform checks
- 11:30CAT simplifies testing
- 12:13CAT in CI/CD
- 13:34CAT use cases
- 15:40Contributing to CAT
- 16:23CAT scenarios
- 17:48Automating production checks
- 18:10Closing
