handy_sql_queries
dbt-audit-helper
handy_sql_queries | dbt-audit-helper | |
---|---|---|
2 | 2 | |
1 | 287 | |
- | 5.2% | |
4.5 | 7.9 | |
10 months ago | 7 days ago | |
The Unlicense | Apache License 2.0 |
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.
handy_sql_queries
-
Data diffs: Algorithms for explaining what changed in a dataset (2022)
If you are looking for an easy way to compare two tables in SQL, whether every single row and every single column are the same, you can use the following technique:
https://github.com/gregw2hn/handy_sql_queries/blob/main/sql_...
-
How to Check 2 SQL Tables Are the Same
This is part of why I don't use MINUS for table value comparisons... All you need is just GROUP BY/UNION ALL/HAVING, using the following technique:
https://github.com/gregw2hn/handy_sql_queries/blob/main/sql_...
dbt-audit-helper
-
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?
deep-diff2 - Deep diff Clojure data structures and pretty print the result
datacompy - Pandas and Spark DataFrame comparison for humans and more!
spark-extension - A library that provides useful extensions to Apache Spark and PySpark.
merkle-tree-solidity - JS - Solidity sha3 merkle tree bridge. Generate proofs in JS; verify in Solidity.
recidiffist - Diffs for structured data
data-diff - Compare tables within or across databases
dbhub.io - A "Cloud" for SQLite databases. Collaborative development for your data. 😊
macrobase-diff - Minimal implementation of Macrobase Diff
diffable-sql
blog