Effortless Low-Code Data Testing
summary
Claims a one-line install of a PowerShell module called cat that runs SQL/DAX checks and integrates into CI/CD (Azure DevOps) to give immediate failure alerts. Examples show a day dimension test catching an end date of 2024 instead of expected 2025 and a cross-system reconciliation across Postgres, SQL Server and Power BI on tens of thousands of rows. Tests can be generated from metadata, exported to DevOps or SQL, and a GUI get Studio is available in the Microsoft Store.
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
50mDataOps 101 – A Better Way to Develop and Deliver Data Analytics
20mDataEngBytes 2023 PER-T1-10 - Matthew Carter
01h 02m1,2,3… testing: is this thing on(line)? Meet your new Microsoft Testing tools
27mDatabase Testing with pytest
58mWho tests their cloud code anyway?
35mIaC Automated Assurance