Veridelta

Veridelta compares two datasets on their primary keys and reports every row that differs under the rules you declare. Nothing is forgiven unless a rule says so, and the exit code tells CI whether the datasets match. Use it to verify a migration or a pipeline change, on a laptop, in CI, or inside a warehouse.

A terminal prints a five-line veridelta.yaml and two three-row CSV files, validates the configuration, runs the comparison, shows one added, one removed, and one changed row, and prints the exit code for CI, 1, beside what 0, 1, and 3 mean.

It runs on Polars. Read the documentation.

Features

Declared rules. Tolerances, null sentinels, regular expressions, value maps, date parsing, casts, and fuzzy text matching apply in nine fixed stages. Nothing is forgiven unless a rule says so, and strict_types fails a column whose type drifts.
Comparison inside the warehouse. Two tables in Snowflake, Databricks, or BigQuery are compared where they are stored, as are two Postgres or DuckDB tables that set pushdown. The rules compile to SQL, and only counts and keys come back. Pushdown lists the exceptions and the services the SQL has run in.
Many sources. CSV, Parquet, JSON, Arrow, Avro, and Excel files, Delta Lake and Iceberg tables, DuckDB files and MotherDuck databases, and Postgres, MySQL, SQL Server, Oracle, SQLite, and other databases. Files and tables are scanned lazily where Polars can.
Built for CI. Exit codes, a JSON summary, a standalone HTML report, a Markdown summary for pull requests, OpenTelemetry metrics, and files of the rows that differ. A GitHub Action and a GitLab CI template post the summary on each pull request.
Checks before a run. veridelta validate reports what would stop a run without reading any rows, and a JSON Schema gives editors completion for configuration files.

Install

uv add veridelta                # or: pip install veridelta
uv add 'veridelta[snowflake]'   # extras: snowflake, databricks, bigquery, delta, iceberg, database, duckdb, excel, fuzzy, mcp, all

Quick start

The smallest configuration names the two files and the keys that pair their rows. The suffix of each path says what format it is:

# veridelta.yaml
primary_keys: [id]
source:
  path: legacy.csv
target:
  path: modern.csv

The recording above runs this file on two three-row files. validate checks the file without reading any rows, and run compares the two files. It exits 0 when they match, 1 when rows differ, and 3 when the run could not finish:

veridelta validate -c veridelta.yaml
veridelta run -c veridelta.yaml

Rules say what counts as a match, column by column. This file forgives one percent on a total and compares phone numbers on their digits alone:

primary_keys: ["transaction_id"]
source:
  path: "legacy.parquet"
target:
  path: "modern.parquet"
rules:
  - column_names: ["grand_total"]
    relative_tolerance: 0.01
  - column_names: ["contact_number"]
    regex_replace: {"[^0-9]": ""}

In Python, DiffEngine compares two LazyFrames with the same models:

import polars as pl
from veridelta import DiffConfig, DiffEngine, DiffRule

result = DiffEngine(
    DiffConfig(
        primary_keys=["user_id"],
        rules=[DiffRule(pattern="^AMT_.*", absolute_tolerance=0.05)],
    ),
    pl.scan_parquet("legacy.parquet"),
    pl.scan_parquet("modern.parquet"),
).run()

if not result.summary.is_match:
    raise SystemExit(f"{result.summary.changed_count} rows differ")

Documentation

Tutorials: five notebooks, from a first comparison in Python to a CI pipeline.
User guide: configuration, sources, rules, pushdown, results, and the command line.
CI integrations: the GitHub Action and the GitLab CI template.
API reference: the public Python interface.
Roadmap: work that is not built yet.

Accessibility

ACCESSIBILITY.md states what Veridelta aims for, the barriers known today, and how to report one.

Contributing

See CONTRIBUTING.md for the development setup and the checks a change must pass.

License

Apache 2.0.

Metadata

Release files for veridelta 0.19.6

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for veridelta 0.19.6
File	Size	Uploaded
veridelta-0.19.6.tar.gz	935.6 kB	Oct 7, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for veridelta 0.19.6
File	Interpreter	ABI	Platform	Reset
veridelta-0.19.6-py3-none-any.whl 132.8 kB Oct 7, 2026	Python 3	none	any	Details

Total release size: 1.1 MB

Release files / veridelta-0.19.6.tar.gz

Download URL	veridelta-0.19.6.tar.gz
Size	935.6 kB
Tags	Source
SHA-256 checksum How to use checksums	`8c3f2ab0d3dad6b12bd51a918283d76db7115770f38222830b3b2cc04ce28d42`
BLAKE2b-256 checksum How to use checksums	`f5b99a6a69e39927db7487a40bd58083c45394674fcbf51ea1504634c3d76c0b`
Upload date	Oct 7, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`uv/0.12.23 {"installer":{"name":"uv","version":"0.12.23","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}`

Release files / veridelta-0.19.6-py3-none-any.whl

Download URL	veridelta-0.19.6-py3-none-any.whl
Size	132.8 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`e28c058919cc8812fe4a8053266a63b9cffccfb2805273ed9dd6da133ccfa7c4`
BLAKE2b-256 checksum How to use checksums	`526d1cda9e2527fe1da8651a714f6821004fe58005ca29d655df11b9ee3461e1`
Upload date	Oct 7, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`uv/0.12.23 {"installer":{"name":"uv","version":"0.12.23","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}`