SQL Server Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs
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: https://github.com/DataResearchLabs/s...
Rule Set #8: https://github.com/DataResearchLabs/s...
Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/s...
Watch related playlist videos:
• SQL Server Scripts for Data Analysts
Connect with me on social media:
LinkedIn: / mpiercead576
YouTube: / @dataresearchlabs
GitHub: https://github.com/DataResearchLabs
Subscribe to my YouTube Channel:
/ @dataresearchlabs
#MSSQL #automation #datavalidation
En esta página del sitio puede ver el video en línea SQL Server Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs de Duración online en buena calidad , que subió el usuario DataResearchLabs 19 agosto 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,435 veces y le gustó 12 a los espectadores. Disfruta viendo!
