Effortless Low-Code Data Testing
summary
Tool demo of cat shows low-code data tests implemented as plain SELECTs that get compared across sources (Postgres, SQL Server, Power BI/Fabric, Databricks, Oracle, Excel/CSV/YAML). Claims billions are wasted on bad data and demonstrates automating checks with three commands install-module cat, import-module cat, invoke project to run tests, publish results into Azure DevOps, and fail builds on mismatches. Also mentions a Community Preview Kit Studio UI in Microsoft Store for onboarding and templated test generation.
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
related talks
19mEffortless Low-Code Data Testing
30mHow to Test BigData/ETL Solutions?
49mFrom the Classroom to the Boardroom – Azure SQL DB through Demos
41mA Cookbook for Testing Data
47mEfficiency up, failed releases down; compliant production data for your test and dev environments
27mDatabase Testing with pytest
50mBringing DevOps to the Database
01h 12mNext-gen SQL Projects with Microsoft.Build.Sql