Recce
Explore, validate, and share data impact before merging
What is Recce? Complete Overview
Recce is a powerful data validation tool designed to help teams understand and validate data changes before merging them into production. It significantly reduces the time required for PR reviews, from days to less than an hour, ensuring data accuracy and reliability. Recce is ideal for data engineers, data scientists, and analytics teams who need to ensure that their data changes do not negatively impact downstream processes. With features like column-level impact analysis, one-click data validation tests, and custom query comparisons, Recce provides a comprehensive solution for data validation. The tool is particularly beneficial for teams without dedicated engineers, offering out-of-the-box functionality that simplifies workflows and boosts productivity.
Recce Interface & Screenshots
Recce Official screenshot of the tool interface
What Can Recce Do? Key Features
Column-level impact analysis
Recce allows users to see exactly which downstream models or columns break when something changes. This feature helps in identifying potential issues before they affect production data.
One-click data validation tests
Users can compare production vs development data with value diff, schema diff, profile diff, and histogram diff. This ensures that any discrepancies are caught early in the development process.
Custom query comparisons
Run any SQL against both production and development environments to see differences. This feature provides flexibility in validating data changes.
Preset validation checks
Recce offers manual checks that can be run on dbt builds, ensuring that data changes meet predefined standards before merging.
Easily export and share validation results
Users can share screenshots and statefiles in their PR or Slack, making it easy to collaborate and communicate data changes.
LLM-powered validation insights
AI analyzes your changes and suggests the best data tests, helping teams make informed decisions about their data changes.
PR comment automation
Validation summaries are posted directly to PR threads, streamlining the review process and ensuring transparency.
Best Recce Use Cases & Applications
PR Review Acceleration
Teams can reduce PR review times from days to less than an hour by using Recce to validate data changes before merging.
Downstream Impact Analysis
Recce helps identify how changes to a major table can impact over 20 downstream processes, ensuring data integrity.
Data Quality Assurance
Recce's validation tests ensure that data changes meet quality standards, reducing the risk of errors in production.
Collaborative Data Validation
Teams can easily share validation results and collaborate on data changes, improving communication and efficiency.
How to Use Recce: Step-by-Step Guide
Sign up for Recce Cloud or download the open-source version from GitHub.
Connect your data sources (e.g., production and development databases) to Recce.
Run one-click data validation tests to compare production and development data.
Review the results, including column-level impact analysis and custom query comparisons.
Share the validation results with your team via PR comments or Slack.
Merge your changes with confidence, knowing that your data has been thoroughly validated.
Recce Pros and Cons: Honest Review
Pros
Considerations
Is Recce Worth It? FAQ & Reviews
The Free plan includes basic features like column-level impact analysis and one-click data validation tests, while the Team plan adds advanced features like PR blocking, automated CI validation, and LLM-powered validation insights.
Yes, Recce is designed to be user-friendly and provides out-of-the-box functionality, making it ideal for teams without dedicated engineers.
Recce reduces PR review times by providing comprehensive data validation tests and impact analysis, ensuring that data changes are thoroughly checked before merging.
Yes, Free plan users can get help in the Recce Discord server.
The Enterprise plan includes advanced features like SSO integration, BYOC deployment, role-based access control, and dedicated support with custom SLAs.