Skip to main content

How it works

Deprecated

As of May 17, 2024, Datafold is no longer actively supporting or developing open source data-diff. For continued access to in-database and cross-database diffing, please check out a free trial of Datafold Cloud. We’re grateful to everyone who made contributions along the way. Please see our blog post for additional context on this decision.

Development testing with Datafold enables you to see the impact of code changes on data as you write the code, in IDE or CLI. It leverages data diff, integrates deeply with dbt and follows the same concepts as deployment testing while allowing to test earlier in the development flow.

Development Testing Workflow

Development testing plugs in the general code+run workflow by adding a diffing step to see how each code change impacts the data. In a nutshell, the workflow follows the following three steps:

  1. Change the dbt code
  2. dbt run to materialize the code changes in development environment
  3. Run data diff to see the impact of code changes on data

Available integrations options

  1. CLI (open-source) - easiest to get started, works with any IDE
  2. CLI + Datafold Cloud - enables visualizations and value-level diffs