Skip to main content

Environment diff tool for dbt

Project description

Recce: DataRecce.io

Helping data teams preview, validate, and ship data changes with confidence.

install   pipy   Python   downloads   license   Slack   InfuseAI Discord Invite  

Book us with Cal.com

Trust, Verify, Ship

Cut dbt review time by 90% and ship accurate data fast

Recce gives data teams a faster, more reliable way to understand, review, and ship changes without all the guesswork or manual overhead.

Quick Start

Installation

Recce offers two packages to fit different use cases:

For full local development and Recce Cloud features:

pip install -U recce
recce server

For CI/CD artifact uploads only (lightweight):

pip install -U recce-cloud
recce-cloud upload

The recce-cloud package is a lightweight CLI tool designed specifically for CI/CD environments where you only need to upload dbt artifacts to Recce Cloud. It has minimal dependencies and installs faster than the full recce package.

Getting Started

You can launch Recce in any dbt project in just two commands:

# cd into your dbt project
pip install -U recce
recce server

(Note: while recce is not version spsecific, dbt-core is currently not compatible with Python 3.13. Please make sure to use Python 3.10 - 3.12.)

This starts Recce locally, where you can explore lineage and run queries. To unlock the full set of diffing tools, such as data comparisons and impact checks, you'll need to prepare two environments to compare against. You can follow our Getting Started and 5-minute Jaffle Shop tutorial to try it out step-by-step.

What You Get

Recce gives you a clear, fast way to understand what your data changes are doing and why they matter. It helps you catch problems early, verify metrics, and share your findings with others, all as part of your normal workflow.

readme

Model and column level diff

Checklist for collaboration

Using Recce for Impact Assessment in dbt PR Review

  • Select nodes in the lineage to perform Checks (diffs) as part of your impact assessment during development or PR review.
  • Add Checks to your Checklist to note observed impacts.
  • Share your Checklist with the PR reviewer.
  • (Recce Cloud) Automatically sync Check status between Recce Instances
  • (Recce Cloud) Block PR merging until all Recce Checks have been approved

Read more about using Recce on our blog.

What’s Included

  • Lineage and impact mapping: Quickly see which models and columns are affected by a change. Navigate lineage down to the column level, and spot breaking changes with clear visual cues.
  • Metric and data comparisons: Use Profile, Value, Top-K, and Histogram Diffs to compare results before and after changes. Validate things like row counts, category distributions, and numeric ranges without writing extra SQL.
  • Query diff: Write and compare any two queries side by side. This is helpful when validating fixes or reviewing changes with teammates.
  • Checklist for reviews and approvals: Turn your validation steps into a checklist. Add notes, rerun checks, and share the results with reviewers or stakeholders. In Recce Cloud, checklists can sync automatically and even block PRs until checks are approved.
  • Secure by design: Recce is SOC 2 compliant to meet enterprise security standards. It runs locally or in your private environment, and your data stays in your warehouse.

👉 Want to dive deeper? Check out the full documentation.

Recce Cloud

Ready to collaborate and move faster as a team? Recce Cloud adds real-time collaboration, automatic checklist sync, and PR gating, so nothing gets merged without a full review.

  • Share checklists across environments
  • Invite stakeholders to review data changes
  • Block merges until all Checks are approved
  • Launch demo links from your CI with full context

Recce Cloud is a hosted version of Recce that standardizes your workflow, keeps teams aligned, and reduces errors—so you can ship data changes with confidence. 👉 View Pricing and Plans

Developer Documentation

If you want to contribute to Recce or test local changes in your dbt project, follow these steps to install the development version.

Installing the Local Dev Version

  1. Clone the repository (if you haven't already):

    git clone https://github.com/DataRecce/recce.git
    cd recce
    
  2. Build the project from the repository root:

    make build
    

    This builds the frontend assets and prepares the package for installation.

  3. Install the local dev version in your dbt project:

    # Navigate to your dbt project
    cd /path/to/your/dbt-project
    
    # Install recce in editable mode (replace with your actual path to the recce repo)
    pip install -e /path/to/recce
    

    Using -e (editable mode) means any changes you make to the Recce source code will be immediately available without reinstalling.

  4. Start the Recce server to verify the installation:

    recce server
    

Development Tips

  • After making frontend changes in js/, run make build again to rebuild the static assets
  • Run make install-dev in the recce repository to install development dependencies
  • Use make test to run the Python test suite
  • Use cd js && pnpm test to run the frontend test suite

For more detailed development guidelines, see CONTRIBUTING.md.

Community & Support

Here's where you can get in touch with the Recce team and find support, add a subscribe to our newsletter option as well:

If you believe you have found a bug on our open source, or there is some missing functionality in Recce, please open a GitHub Issue.

Recce on the web

You can follow along with news about Recce and blogs from our team in the following places:

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

recce-1.46.2.tar.gz (2.3 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

recce-1.46.2-py3-none-any.whl (2.4 MB view details)

Uploaded Python 3

File details

Details for the file recce-1.46.2.tar.gz.

File metadata

  • Download URL: recce-1.46.2.tar.gz
  • Upload date:
  • Size: 2.3 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.20

File hashes

Hashes for recce-1.46.2.tar.gz
Algorithm Hash digest
SHA256 5e39f000fec7182fd2a5b81a09f54b4c50de968c5a9faa6af65f8549b5b4c3be
MD5 de260340434353edaf7eda7873843b79
BLAKE2b-256 144c5e5662138a0c7627d8ea239ee359281332b43c4e3e9b7e78bdf59cbb5479

See more details on using hashes here.

File details

Details for the file recce-1.46.2-py3-none-any.whl.

File metadata

  • Download URL: recce-1.46.2-py3-none-any.whl
  • Upload date:
  • Size: 2.4 MB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.20

File hashes

Hashes for recce-1.46.2-py3-none-any.whl
Algorithm Hash digest
SHA256 0b027c8dfcc1aca2bf65133185a9897aad3ce7c9521dda7fb73c34acadee8f77
MD5 2045508d0f2f5af98c77162477ff91a8
BLAKE2b-256 dbd427b2dbb4cde646ed6b69b6af7bb1d81d3de00cd633459f7decc1fa85449a

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page