Effortless Low-Code Data Testing
summary
Product called Cat is a PowerShell module that installs in seconds and runs data tests from YAML or Excel, comparing SQL Server, Postgres, Power BI (via DAX), Fabric, Excel/CSV and more across systems. Example: a day dimension test flags an end year 2024 vs expected 2025; another check reconciles tens of thousands of rows between source and DW. Tests auto-generate from metadata, export to SQL or Excel, run in pipelines (free until scheduled), and integrate with Azure DevOps and a simple Get Studio UI.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 3:33Simple date dimension test
- 8:11Incremental data loads testing
- 11:45Advanced testing scenarios
- 16:23How to get started with the tool
- 18:08Q&A
related talks
20mEffortless Low-Code Data Testing
19mEffortless Low-Code Data Testing
25mTesting Data Pipelines
39mModern Data Pipelines Testing Techniques: A Visual Guide
20mDataEngBytes 2023 PER-T1-10 - Matthew Carter
01h 02m1,2,3… testing: is this thing on(line)? Meet your new Microsoft Testing tools
38mThe Power of Atomic Automated Tests
20mData Mesh testing: An opinionated view of what good looks like