Elementary OSS vs Recce
By Ari Bajo - data engineer turned writer.
Updated on November 13, 2026
Summary
Elementary OSS and Recce are both free and work with dbt, but they do different jobs: Elementary OSS adds anomaly detection tests that run with your dbt project, and Recce shows the data impact of a pull request before merge. Many dbt teams could run both.
Elementary OSS and Recce differ on 22 of the 63 features in my data quality feature matrix and share 9.
Elementary OSS vs Recce at a glance
| Criterion | Elementary OSS | Recce |
|---|---|---|
| What it is | Elementary OSS is an open-source dbt package by Boomi that adds anomaly detection tests and a CLI-generated data observability report to dbt projects. | Recce is an AI data review agent for dbt pull requests, with open-source data diff, schema diff, downstream impact analysis, and column-level lineage. |
| Best for | Dbt teams that want free anomaly detection tests inside their existing dbt project, without a cloud account. | Dbt teams that want reviewers to see the data impact of code changes before approving a pull request. |
| Category | Data observability | Shift-left data quality |
| Core strength | Free dbt anomaly detection — tests and a CLI-generated report inside an existing dbt project | dbt pull request review — data diffs, column lineage and impact radius before merge |
| Pricing | Free, open source | Free, open source; paid plans from $250/month (1,000 reviews) |
| Free option | Open source | Open source |
| Deployment | Self-hosted | SaaS, self-hosted |
| Features | 25 of 63 tracked | 15 of 63 tracked |
| Notable caveat | dbt-only, and the report is CLI-generated rather than hosted | No monitors, alerts or schedules; PR gating and AI summary are Cloud-only |
Key differences between Elementary OSS and Recce
The 22 features where only one of them is confirmed, by feature group. Each line says how the tool does it and links the source.
Data Testing
SQL Table Tests
Elementary OSS: Wraps all native dbt tests — not_null (completeness), unique (uniqueness), accepted_values (validity), relationships (consistency/RI) — plus dbt-utils for date ranges and custom SQL assertions (docs).
Recce: not supported.
DataFrame Tests
Elementary OSS: Python tests allow writing custom test logic as Python scripts executed inside the dbt environment (docs).
Recce: not supported.
Unstructured Data Tests
Elementary OSS: The elementary.unstructured_data_validation dbt test (Beta, v0.18+) uses warehouse-native LLM functions to validate free-text columns against plain-English expectations — no data leaves the warehouse (docs).
Recce: not supported.
Data Diff
Elementary OSS: not supported.
Recce: Value Diff joins base and PR versions on a primary key and reports added, removed and changed rows with a match % per column (docs).
Data Observability
Anomaly Detection
Elementary OSS: Anomaly detection tests use historical baselines to detect volume, freshness, schema, column, and dimension anomalies without hardcoded thresholds (docs).
Recce: not supported.
Freshness Monitors
Elementary OSS: Freshness anomaly and Event freshness anomaly tests detect stale tables and delays in event ingestion (docs).
Recce: not supported.
Volume Monitors
Elementary OSS: Volume anomaly test detects drops or spikes in row counts compared to historical baselines (docs).
Recce: not supported.
Schema Monitors
Elementary OSS: Schema change and schema change from baseline tests detect added, dropped, or retyped columns (docs).
Recce: not supported.
Field Monitors
Elementary OSS: Column anomaly tests track null count, distinct count, min, max, avg, and standard deviation per column as time series (docs).
Recce: not supported.
Distribution Monitors
Elementary OSS: Column anomaly tests monitor value distributions per column and detect abnormal shifts in expected patterns (docs).
Recce: not supported.
Segment Monitors
Elementary OSS: Dimension anomaly test tracks counts per dimension value (e.g., by country or status) and detects distribution shifts between them (docs).
Recce: not supported.
Custom SQL Monitors
Elementary OSS: Custom SQL dbt tests allow any SQL query to be used as an assertion; also supports custom singular tests (docs).
Recce: not supported.
Monitors-as-Code
Elementary OSS: All tests and monitors are defined in dbt YAML/SQL files, version-controlled and deployed through dbt CI/CD (docs).
Recce: not supported.
Incident Management
Alert Notifications
Elementary OSS: Sends dbt test failure alerts to Slack, email, and other configured channels via the CLI (docs).
Recce: not supported.
Data Quality Analytics
Data Quality Dashboards
Elementary OSS: Generates a self-hosted HTML observability report showing dbt test results, run history, and anomaly trends (docs).
Recce: not supported.
Workflows
Scheduling
Elementary OSS: Runs on the dbt schedule; can be orchestrated via Airflow, Prefect, or any scheduler that triggers dbt runs (docs).
Recce: not supported.
Circuit Breakers
Elementary OSS: Elementary tests are dbt tests run by dbt test or dbt build, so a failing test with severity error fails the pipeline, before dependent models build (docs).
Recce: not supported.
MCP Server
Elementary OSS: not supported.
Recce: recce mcp-server gives Claude Code, Cursor and other agents lineage, schema, row count, value, profile and query diff tools (docs).
Security
SSO
Elementary OSS: not supported.
Recce: Recce Cloud supports SSO on paid plans (docs).
RBAC
Elementary OSS: not supported.
Recce: Recce Cloud has Owner, Admin and Member roles, with project-level permissions on Enterprise (docs).
Compliance Certifications
Elementary OSS: not supported.
Recce: Recce shows a SOC 2 badge linking to its trust center (website).
Deployment
SaaS Deployment
Elementary OSS: not supported.
Recce: Recce Cloud is a hosted service connected to your Git provider and warehouse (docs).
Elementary OSS or Recce: which to choose
Choose Elementary OSS if
You want to catch issues in production data on every dbt run.
Choose Recce if
Bad changes slip through code review and you want data diffs on each pull request.
What both Elementary OSS and Recce do
9 features supported by both
- Data Testing: Table Comparison Tests, Inspect Failed Rows
- Data Observability: Data Profiling
- Data Lineage: Table-Level Lineage, Column-Level Lineage, Impact Analysis
- Workflows: CI/CD Integrations, dbt Integration
- Deployment: Self-Hosted Deployment
Elementary OSS vs Recce integrations
Elementary OSS lists 23 integrations and Recce 8; 6 are on both lists. See the integrations matrix for all tools.
- Both (6): Snowflake, Google BigQuery, Amazon Redshift, Databricks SQL, dbt, GitHub Workflows
- Only Elementary OSS (17): Google OAuth, PostgreSQL, Amazon Athena, Trino, ClickHouse, Dremio, Apache Spark, DuckDB, Microsoft Fabric, Microsoft SQL Server, OpenText Analytics Database (Vertica), Slack, Amazon S3, Google Cloud Storage, Azure Blob Storage, Apache Airflow, Prefect
- Only Recce (2): GitHub, GitLab
Elementary OSS vs Recce FAQ
What is the difference between Elementary OSS and Recce?
Elementary OSS and Recce are both free and work with dbt, but they do different jobs: Elementary OSS adds anomaly detection tests that run with your dbt project, and Recce shows the data impact of a pull request before merge. Many dbt teams could run both.
Is Elementary OSS or Recce cheaper?
Elementary OSS: Free, open source (open source). Recce: Free, open source; paid plans from $250/month (1,000 reviews) (open source). Prices come from each vendor's pricing page.
Which has more features, Elementary OSS or Recce?
Elementary OSS supports 25 and Recce 15 of the 63 features in my data quality feature matrix. They share 9 and differ on 22; only Elementary OSS has SQL table tests, dataframe tests and unstructured data tests; only Recce has data diff, MCP server and SSO.
Is Elementary OSS open source?
Yes, both Elementary OSS and Recce are open source.
Can Elementary OSS and Recce be self-hosted?
Elementary OSS: Self-hosted. Recce: SaaS, self-hosted.
Data from my data quality feature matrix, checked against each vendor's docs, and pricing pages. For more options, see the best data quality tools.
Evaluating data tools in 2026?
I curate the most comprehensive lists of data tools, up-to-date comparison tables, and actionable market guides for data teams. More useful than a Gartner report. More reliable than asking AI. Next up: Data FinOps.