This video walks you through 5 powerful advanced data validation test case examples. These table-level tests cover thresholds for column null rates and value frequencies observed. These tests also covering monitoring table structure and table data changes.
You can refactor and re-use the samples in your projects. The scripts in the demo are all out on Github along with 66 total sample validation tests along with a basic and an advanced script for automating the tests.
------- Chapter Timestamps (click to jump forward): -----------------------------
0:00 - Intro
0:12 - Introducing Rule Set #3 - Heuristic Thresholds
0:49 - Demo: T008 - Null Rate Thresholds
2:39 - Demo: T009 - Value Frequency Thresholds
4:34 - Introducing Rule Set #8 - Diff Checks
5:06 - Demo: T059 - Table Structure (Schema) Changes
7:05 - Demo: T060 - Table Data Changes (Static SQL Snapshot)
9:34 - Demo: T061 - Table Data Changes (Dynamic Table Compare)
13:53 - How to Download SQL Scripts in this Video
15:26 - The End
Downloads:
- Rule Set #3: [ Ссылка ]
- Rule Set #8: [ Ссылка ]
- Multi-Platform Data Validation Scripts: [ Ссылка ]
Watch related playlist videos:
- [ Ссылка ]
Connect with me on social media:
- LinkedIn: [ Ссылка ]
- YouTube: [ Ссылка ]
- GitHub: [ Ссылка ]
Subscribe to my YouTube Channel:
- [ Ссылка ]
#MSSQL #automation #datavalidation
