Skip to main content

Data Quality

Trust Your Data

Quality scoring across five dimensions, schema enforcement, and self-healing SQL across every pipeline layer. Surface data issues alongside pipeline execution.

How to Use It

One dashboard, nine tabs. Open it from Data Quality in the sidebar.

Overview

Score cards, quality by layer, recent runs, and active alerts, at a glance.

Checkpoints

Where checks actually live. Create one, run it, and see its pass/fail history.

Templates

A gallery of ready-made checks (not-null, uniqueness, range, and more). Browse and apply instead of writing one from scratch.

Custom

Build your own check with a form: pick a column, a condition, and save it, no code required.

Parameters

Values a check compares against (a threshold, a valid range) that you can update without rewriting the check itself.

Batches

Pick exactly which table, filter, or sample a check runs against, set separately per layer since Bronze, Silver, and Ready rarely share the same columns.

Actions

Where a failed check goes: Slack, email, PagerDuty, or a custom webhook.

AI Assistant

Profiles your data, suggests checks with a confidence bar on each, and applies the ones you pick in bulk. Refine with a follow-up prompt instead of starting over.

Stores

Where results and check definitions are physically kept: local files by default, or S3, GCS, Azure, or a database if you need that.

Fastest path to your first check: open the AI Assistant tab and let it profile the table and suggest checks, or open Templates and apply a ready-made one. Either way, hit "Run All Validations" from the header once you have a few in place.

Quality Dimensions

Four dimensions that define whether your data is ready for analytics.

Completeness
How many values are non-null across your dataset.
  • Null percentage per column
  • Required field enforcement
  • Row count vs. expected thresholds
Uniqueness
Duplicate detection across key columns.
  • Duplicate row detection
  • Primary key uniqueness validation
  • Cross-column composite key checks
Validity
Whether values conform to expected formats and ranges.
  • Type conformance (dates, numbers, strings)
  • Range and boundary checks
  • Regex pattern matching
Freshness
How recently the data was updated relative to expectations.
  • Last ingestion timestamp
  • Stale data alerting
  • Pipeline execution frequency

Quality Scores

Tables are scored from 0 to 100 across completeness, uniqueness, validity, consistency, and freshness — combining into a single number you can track over time.

90 — 100
Excellent

Data is clean, complete, and fresh. Safe for dashboards.

70 — 89
Acceptable

Minor issues. Review flagged columns before using in Gold.

0 — 69
Needs Attention

Significant quality issues. Investigate before proceeding.

Automated Profiling

Profiling runs automatically when data is ingested. Every column gets statistical analysis without manual configuration.

Column-Level Statistics

Min, max, mean, median, standard deviation, null percentage, and distinct count for every column.

Type Distribution

Breakdown of inferred vs. actual types. Catches mixed-type columns (e.g., strings in a numeric field).

Value Frequency

Top values and their frequencies per column. Useful for spotting unexpected categories or outliers.

Sample Preview

View sample rows alongside statistics. Profiles run against your actual data, not a separate sample.

Schema Enforcement & Self-Healing SQL

The platform enforces safe schema evolution and auto-corrects SQL errors at runtime — fixing column references, type mismatches, and conversion errors automatically so pipelines recover without manual intervention.

Integrated Across Every Layer

Quality checks are embedded in the pipeline, not bolted on after.

Bronze Layer

Ingestion

Profile raw data on ingestion. Catch source issues (missing fields, type changes) before they propagate.

Silver Layer

Transformation

Validate transformations produced correct output. Check that deduplication and cleaning worked.

Gold Layer

Analytics

Verify aggregated metrics are within expected bounds. Prevent bad data from reaching dashboards.

Pipeline Execution

Orchestration

Quality checks run as part of the DAG. If a table fails validation, downstream nodes can be paused.

Quality built in

Stop discovering bad data in your dashboards.

Profiling and scoring run on every ingestion. No separate tool to configure.