dbt-audit-helper
Useful macros when performing data audits (by dbt-labs)
datacompy
Pandas and Spark DataFrame comparison for humans and more! (by capitalone)
dbt-audit-helper | datacompy | |
---|---|---|
2 | 4 | |
287 | 396 | |
5.2% | 11.1% | |
7.9 | 7.5 | |
7 days ago | 10 days ago | |
Python | ||
Apache License 2.0 | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
dbt-audit-helper
Posts with mentions or reviews of dbt-audit-helper.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-07-26.
-
How to Check 2 SQL Tables Are the Same
In case you haven't tried dbt (www.getdbt.com / "Data Build Tool") - there's a whole package ecosystem that solves for things like this. The one that came to mind is "dbt-audit-helper": https://github.com/dbt-labs/dbt-audit-helper#compare_relatio...
It's kind of like PyPI/DockerHub for SQL. Lots of cool stuff in there...here's link to the package hub: https://hub.getdbt.com/
-
What do like and dislike about your job as a DE?
Cool, I’ve never used row(), I’ll definitely check that out! I’ve tried the dbt audit helper package and I liked it except that I really don’t like the dbt cloud console. Anyone know how to use that package in a local shell?
datacompy
Posts with mentions or reviews of datacompy.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-07-26.
- How to Check 2 SQL Tables Are the Same
-
Comparing 2 CSV files
datacompy is a package to compare 2 pandas dataframes
- Performing Data Tests on External Data/Complex Data Quality Checks
-
Best Practice When Comparing Data Across Two SQL Servers in Python
https://github.com/capitalone/datacompy will allow you to compare two tables/dataframes against one another, and see detailed results on the difference.
What are some alternatives?
When comparing dbt-audit-helper and datacompy you can also consider the following projects:
merkle-tree-solidity - JS - Solidity sha3 merkle tree bridge. Generate proofs in JS; verify in Solidity.
koalas - Koalas: pandas API on Apache Spark