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

    CriterionElementary OSSRecce
    What it isElementary 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 forDbt 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.
    CategoryData observabilityShift-left data quality
    Core strengthFree dbt anomaly detection — tests and a CLI-generated report inside an existing dbt projectdbt pull request review — data diffs, column lineage and impact radius before merge
    PricingFree, open sourceFree, open source; paid plans from $250/month (1,000 reviews)
    Free optionOpen sourceOpen source
    DeploymentSelf-hostedSaaS, self-hosted
    Features25 of 63 tracked15 of 63 tracked
    Notable caveatdbt-only, and the report is CLI-generated rather than hostedNo 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.

    Elementary OSS profile Elementary OSS alternatives

    Choose Recce if

    Bad changes slip through code review and you want data diffs on each pull request.

    Recce profile Recce alternatives

    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.

    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.