~/talk

Integrate Data Quality into your processes

Talkat SQLBits 2023 · 2023-03-14..03-18· [data-engineering]
links:none on file
slides:none on file

HEDDA.IO supplies a versioned knowledge base of domains, members and rulebooks (regex, lookups, fuzzy algorithms like Levenshtein and phonetics) and exposes Runners to apply those rules where the data lives: a distributed Spark Runner (Databricks/Synapse) for batch scale, a .NET Runner for apps, a Web REST Runner for CI/CD and a single-row processing Azure Function for transactional checks. It returns corrected or invalid row sets, emits profiling statistics back to the portal, but does not do source row-count reconciliation or Power BI semantic-model tests yet.

AI-written summary · about

  1. 0:00Introduction and speakers
  2. 1:03What is data quality
  3. 3:13Why data quality is overlooked
  4. 5:06Real-world data quality issues
  5. 7:18Introducing her IO solution
  6. 11:10her IO web UI overview
  7. 13:43Members and synonyms in knowledge bases
  8. 14:05Rulebooks and versioning
  9. 15:10Creating business rules
  10. 16:54Complex rule validation flows
  11. 18:19Actions and data corrections
  12. 19:44Dataset-level data quality rules
  13. 21:09Q&A on data synchronization
  14. 22:57Integrating data quality into pipelines
  15. 24:44Introducing Runners for integration
  16. 26:31Demo in Databricks notebook
  17. 27:56Performance and scalability
  18. 31:34Q&A on source system validation
  19. 32:37Integration tests and system connections
  20. 34:27Demo in Azure Synapse
  21. 35:31Demo in .NET Interactive notebook
  22. 37:19Q&A on state transition constraints
  23. 38:25Working with corrected data
  24. 40:51Fuzzy search algorithms
  25. 43:59Different Runners for use cases
  26. 45:02Web Runner and REST API
  27. 45:43Q&A on analytical model testing
  28. 47:36Statistics and historical tracking
  29. 49:02Q&A wrap-up and next steps
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.