dbt-audit-helper
Useful macros when performing data audits (by dbt-labs)
| diffable-sql | dbt-audit-helper | |
|---|---|---|
| 1 | 2 | |
| 0 | 285 | |
| - | 4.6% | |
| 4.5 | 7.9 | |
| 11 months ago | 25 days ago | |
| Python | ||
| - | 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.
diffable-sql
Posts with mentions or reviews of diffable-sql.
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
Slightly related: I recently needed to compare several large databases for schema differences. The output from `pg_dump` isn't very diff-friendly, so I built this[1].
1. https://github.com/orf/diffable-sql
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?
What are some alternatives?
When comparing diffable-sql and dbt-audit-helper you can also consider the following projects:
datacompy - Pandas and Spark DataFrame comparison for humans and more!
dbhub.io - A "Cloud" for SQLite databases. Collaborative development for your data. 😊
merkle-tree-solidity - JS - Solidity sha3 merkle tree bridge. Generate proofs in JS; verify in Solidity.
data-diff - Compare tables within or across databases
blog
handy_sql_queries
diffable-sql vs datacompy
dbt-audit-helper vs datacompy
diffable-sql vs dbhub.io
dbt-audit-helper vs merkle-tree-solidity
diffable-sql vs merkle-tree-solidity
dbt-audit-helper vs data-diff
diffable-sql vs blog
dbt-audit-helper vs dbhub.io
diffable-sql vs data-diff
dbt-audit-helper vs handy_sql_queries
diffable-sql vs handy_sql_queries
dbt-audit-helper vs blog