noyrotbart/re-data

re_data - data quality framework

re_data

re_data is a framework to improve data quality in your company, build on top of dbt.

• create a data quality project for your organization to monitor and improve the quality of your data,
• compute data quality metrics for all your tables and add your own code computing those,
• look for anomalies in all your metrics and investigate problematic data

Key features

Data quality metrics

re_data creates data quality metrics schema in your data warehouse containing metrics for all your tables (or only those you would like to monitor) Metrics schema contains information about:

• time since last records were added
• number of records added
• number of missing values in columns over time
• min/max/avg of values in all your columns
• string lengths in all your columns

Think about it as an INFORMATION_SCHEMA on steroids 💪 And this is just a start and in your project, you can compute many other data quality metrics specific to your organization.

Detecting anomalies

re_data looks at metrics gathered and alerts if those are suspicious, comparing to data saw in the past. This means situations like those:

• sudden drops or increases in the volume of new records added to your tables
• longer than expected break between data arrivals
• increase in NULL values in one of your columns
• different maximal/minimal/avg numbers in any of table columns

Will be detected. All data including anomalies is saved directly into your data warehouse so you can easily integrate any existing alerting with it.

Data testing

re_data supports writing data tests by adding dbt_expectations library (and some of our test macros) to dbt project created. We recommend using it, to test both:

• tables you are monitoring
• metrics about your data created by re_data

Getting started

Follow our getting started toy shop tutorial! here 🎈🚙 🦄

Docs

More details on tables created by re_data through dbt package are on the project Github https://github.com/re-data/dbt-re-data and docs for this package: here

Community

Join Slack for questions about using re_data and discussion with people making it 🙂

Integrations

We support almost all of the main data warehouses supported by dbt. We plan to add support for Spark (now officially supported by dbt).

Integration		Status
	BigQuery	Supported
	PostgreSQL	Supported
	Redshift	Supported
	Snowflake	Supported
	Apache Spark	Planned

License

re_data is licensed under the MIT license. See the LICENSE file for licensing information.

Contributing

We love all contributions 😍 bigger and smaller.

Check out the current list of issues here and see if you like anything from there. Also, feel welcome to join our Slack and suggest ideas or set up a live session here.

And if you got this far and like what we are building, support us! Star https://github.com/re-data/re-data on Github 🤩