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
In questa pagina del sito puoi guardare il video online SQL Server Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs della durata di online in buona qualità , che l'utente ha caricato DataResearchLabs 19 agosto 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,435 volte e gli è piaciuto 12 spettatori. Buona visione!
