> ## Documentation Index
> Fetch the complete documentation index at: https://docs.textql.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Quality & Validation Deep-Dive

> A workshop of short, hands-on modules for data engineers and analytics engineers who need to trust — and prove — answer accuracy. The thesis throughout: accuracy is checked, not...

<p>A workshop of short, hands-on modules for <b>data engineers and analytics engineers</b> who need to trust — and <i>prove</i> — answer accuracy. The thesis throughout: <b>accuracy is checked, not asserted.</b> Golden datasets pinned to numbers the org already trusts, eval cases that exercise edge conditions, drift detection on a schedule, reconciliation workflows for when systems disagree, and a validation agent that runs the moment data lands.</p>
<p>Total time: <b>about 2 hours.</b></p>
<p>Builds on <a href="../build-your-ontology/"><b>Build Your Ontology, End to End</b></a> and <a href="../ontology-operations/"><b>Ontology Operations</b></a> — this workshop assumes governed definitions exist and doesn't re-teach the build; it teaches the proof.</p>

## Who this is for

<ul><li>Data/analytics engineers accountable for "is this number right?"</li><li>Ontology owners who need tests, not vibes, behind their definitions</li><li>Teams burned by a silent upstream change that shipped wrong numbers for a week</li><li>Anyone preparing for an audit, a board cycle, or a regulator</li></ul>

## What you'll be able to do

<table><tr><th>After module</th><th>You can...</th></tr><tr><td>0</td><td>Map every way an answer goes wrong to the defense that catches it</td></tr><tr><td>1</td><td>Build golden queries pinned to numbers the org already trusts</td></tr><tr><td>2</td><td>Generate and curate eval cases that exercise definitions and edge cases</td></tr><tr><td>3</td><td>Run drift detection on a schedule, distinguishing data drift from definition drift</td></tr><tr><td>4</td><td>Reconcile two disagreeing systems to the exact fork, and record the resolution</td></tr><tr><td>5</td><td>Deploy a data-quality agent triggered by ETL completion</td></tr><tr><td>6</td><td>Write the quality runbook: owners, cadences, and what a red alert triggers</td></tr></table>

## Workshop modules

<table><tr><th>Module</th><th>Time</th></tr><tr><td>0 · The Trust Stack</td><td>10 min</td></tr><tr><td>1 · Golden Datasets</td><td>20 min</td></tr><tr><td>2 · Validation Sets & Eval Cases</td><td>20 min</td></tr><tr><td>3 · Drift Detection on a Schedule</td><td>20 min</td></tr><tr><td>4 · Reconciliation Workflows</td><td>20 min</td></tr><tr><td>5 · The Data-Quality Feed Agent</td><td>15 min</td></tr><tr><td>6 · The Quality Runbook</td><td>15 min</td></tr></table>

## How to use this workshop

<ol><li>Prerequisites: a connected warehouse and an existing ontology with governed metrics (the build workshops above if not).</li><li>Work <b>in order</b> — golden datasets (Module 1) are the foundation every later module schedules, extends, or operationalizes.</li><li>Swap <code>\[bracketed]</code> placeholders for your metrics, tables, and trusted sources.</li></ol>

<Accordion title="For facilitators — running this as a guided session">
  <p><b>T-minus-1-day pre-flight:</b> run the workshop's key prompts end-to-end in the session workspace — confirm logins, connectors, and the features this workshop touches are enabled for every attendee; have a fallback demo workspace ready in case a customer connector fails live. <b>Pacing:</b> when a long prompt is running (2–4 min), fire it first, then discuss the concept while Ana works — never watch a spinner in silence. If behind schedule, cut sections marked optional, never the checkpoints. <b>Group sessions:</b> attendees drive, you narrate; collect every miss or wrong answer in a shared doc — that list is the ontology backlog. With 10+ attendees on one warehouse, stagger the heavy prompts.</p>
</Accordion>
