VOOZH about

URL: https://thenewstack.io/datafold-integrates-with-dbt-automates-sql-based-data-testing/

⇱ Datafold Integrates with dbt, Automates SQL-Based Data Testing - The New Stack


TNS
SUBSCRIBE
Join our community of software engineering leaders and aspirational developers. Always stay in-the-know by getting the most important news and exclusive content delivered fresh to your inbox to learn more about at-scale software development.
REQUIRED
It seems that you've previously unsubscribed from our newsletter in the past. Click the button below to open the re-subscribe form in a new tab. When you're done, simply close that tab and continue with this form to complete your subscription.
The New Stack does not sell your information or share it with unaffiliated third parties. By continuing, you agree to our Terms of Use and Privacy Policy.
Welcome and thank you for joining The New Stack community!
Please answer a few simple questions to help us deliver the news and resources you are interested in.
REQUIRED
REQUIRED
REQUIRED
REQUIRED
REQUIRED
Great to meet you!
Tell us a bit about your job so we can cover the topics you find most relevant.
REQUIRED
REQUIRED
REQUIRED
REQUIRED
REQUIRED
Welcome!

We’re so glad you’re here. You can expect all the best TNS content to arrive Monday through Friday to keep you on top of the news and at the top of your game.

What’s next?

Check your inbox for a confirmation email where you can adjust your preferences and even join additional groups.

Follow TNS on your favorite social media networks.

Become a TNS follower on LinkedIn.

Check out the latest featured and trending stories while you wait for your first TNS newsletter.

PREV
1 of 2
NEXT
VOXPOP
As a JavaScript developer, what non-React tools do you use most often?
Angular
0%
Astro
0%
Svelte
0%
Vue.js
0%
Other
0%
I only use React
0%
I don't use JavaScript
0%
Thanks for your opinion! Subscribe below to get the final results, published exclusively in our TNS Update newsletter:
NEW! Try Stackie AI
From clobbered drafts to real-time sync
Apr 14th 2026 10:00am, by David Moore
TypeScript 6.0 RC arrives as a bridge to a faster future
Mar 14th 2026 9:00am, by Darryl K. Taft
Mastra empowers web devs to build AI agents in TypeScript
Jan 28th 2026 11:00am, by Loraine Lawson
2022-04-18 09:14:58
Datafold Integrates with dbt, Automates SQL-Based Data Testing
news,
Data

Datafold Integrates with dbt, Automates SQL-Based Data Testing

Datafold partners with dbt Labs to integrate automated data test coverage into the data engineering process.
Apr 18th, 2022 9:14am by Esin Alpturk and Andrew Brust
👁 Featued image for: Datafold Integrates with dbt, Automates SQL-Based Data Testing

Most data quality platforms focus on data quality issues once they are already manifesting in production, which can have knock-on effects on the business side. For example, deployment of bad data could cause people to look at inaccurate dashboards and make poor business decisions before any data quality issues were discovered. Monitoring is important, but detecting and fixing data quality issues prior to using data in production is a better solution. It is faster, easier, and most cost-efficient to fix an issue before the damage is done.

Datafold, founded in 2020, is focused on helping developers and data engineers overcome production data quality issues. The company builds tools to address data quality issues during the development phase, through automation of data testing. Automation is critical; it’s simply not possible to cover any meaningful portion of data with manually written tests. The company says it’s the only player focused on the automation of testing data within the developer workflow.

School of Hard Knocks

Gleb Mezhanskiy, the founder and CEO of Datafold, said the challenges he faced as a data engineer at Lyft led to the foundation of Datafold. He explained how, in one case, a deployed hotfix compromised an entire data pipeline, corrupting dashboards and machine learning feature sets, bringing the day’s productivity to a standstill.

Such experiences provided Mezhanskiy with the inspiration to build tools that prevent this type of production data incident. Mezhanskiy said, “At Lyft, I realized the tools for data engineers that can help automate a lot of manual tasks around data testing, data management, data observability, and lineage can be really helpful.”

Shifting Left

Datafold recently announced a partnership with dbt Labs, makers of dbt, a leading, open source data transformation tool. The partnership brings the fundamentals of reliability engineering from software engineering, such as version control, staging environments, CI/CD, and reliable change management into the data community. It also takes those practices to the next level by providing automation of testing and column-level lineage, the company said.

With the new integration, Datafold and dbt together ensure every code change gets full test coverage, which tests the most important assertions or assumptions about data. They deliver column-level lineage, Data Diff (regression testing for ETL) for dbt, and shareable impact reports. This increases the productivity of data teams by helping them save time on manual testing and, therefore, keeps them focused more on building better products.

How It Works

The new integration can be embedded within the workflow simply by going to dbt Cloud, getting the API key and plugging it into Datafold. Users can then install the Github application for Datafold to get automation for testing that works well with dbt Cloud and Github. Integration with Github helps users see the impact of their changes on data before deploying to production. Datafold, when combined with Github, runs Data Diff as soon as a pull request is opened, so users can see how the change in the source code is going to affect the data. The effect is analyzed in terms of number of rows, schema, primary key, and column differences.

Users can build a Datafold app to see a detailed explanation of the impact of their desired change. The impact of changes can also be visualized and explored at the distribution level so, for example, a skew or feature drift can be prevented before it hampers machine learning model performance. Additionally, Datafold’s column-level lineage capability provides information on how data flows between columns. This enables users to see how a change made to an upstream table can affect a downstream table.

Overall, Datafold enables users to test data for issues that are hard to account for manually. The main goal of all the new integration is to prevent issues before a change takes effect. That makes pull requests an important starting point since that is when developers collaborate to make changes.

Discovering the Future

Datafold has been automating the change management process with regression testing, making it possible to detect data quality issues using column-level lineage, which gives them an advantage in tracing and detecting anomalies while also showing where they are located.

Data lineage, and the access to so much valuable metadata, also puts Datafold in a unique position to improve data discovery, provide information on how data is related, and exchange metadata between tools to enable a cohesive experience. Datafold plans to continue building more automation on top of what it already offers. While the company is not intending its platform to become a full-fledged data discovery tool, Datafold does want it to be part of the data workflow.

Better Together

The data product ecosystem is still fragmented, and arguably a platform like Datafold’s adds some intricacy to the stack. However, companies are progressively joining forces, and such partnerships do simplify things, mitigating the complexity of adopting solutions from multiple vendors, and helping overcome integration issues between different products.

Datafold’s new integration has a laudable goal: to improve the data engineering workflow and help companies scale their analytics more reliably

TRENDING STORIES
SHARE THIS STORY
TRENDING STORIES
SHARE THIS STORY
TRENDING STORIES
TNS DAILY NEWSLETTER Receive a free roundup of the most recent TNS articles in your inbox each day.
The New Stack does not sell your information or share it with unaffiliated third parties. By continuing, you agree to our Terms of Use and Privacy Policy.