handy_sql_queries
lakeFS
handy_sql_queries | lakeFS | |
---|---|---|
2 | 48 | |
1 | 4,097 | |
- | 1.6% | |
4.5 | 9.8 | |
10 months ago | 4 days ago | |
Go | ||
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_...
lakeFS
-
A Step-by-Step Guide to Implementing Data Version Control
# Download the LakeFS binary wget https://github.com/treeverse/lakeFS/releases/latest/download/lakefs # Make the binary executable chmod +x lakefs # Initialize LakeFS with S3 as the storage backend ./lakefs init --backend s3 --s3-gateway-endpoint --s3-region --s3-force-path-style --s3-access-key --s3-secret-key
-
Jujutsu: A Git-compatible DVCS that is both simple and powerful
Might want to look at purpose built tools for that such as lakeFS (https://github.com/treeverse/lakeFS/)
* Disclaimer: I'm one of the creators/maintainers of the project.
-
Data diffs: Algorithms for explaining what changed in a dataset (2022)
Might want to checkout lakeFS: https://github.com/treeverse/lakeFS
(full disclosure: I'm one of the creators)
-
Transactions in Spark / Delta lake?
Take a look at https://github.com/treeverse/lakeFS -
- LakeFS – Version Control for Big Data
- DuckDB <3 LakeFS
- We built an open-source project (3.1K stars on GitHub) for data version control
-
How are you incrementally testing your data pipelines as you develop them?
I mean if you're ready to adopt a new framework into your ecosystem this is one of the major usecases for LakeFS.
- Git-for-Data
- LakeFS: Git-like versioning for object stores
What are some alternatives?
deep-diff2 - Deep diff Clojure data structures and pretty print the result
dvc - 🦉 ML Experiments and Data Management with Git
spark-extension - A library that provides useful extensions to Apache Spark and PySpark.
delta - An open-source storage framework that enables building a Lakehouse architecture with compute engines including Spark, PrestoDB, Flink, Trino, and Hive and APIs
recidiffist - Diffs for structured data
git-lfs - Git extension for versioning large files
datacompy - Pandas and Spark DataFrame comparison for humans and more!
Ory Kratos - Next-gen identity server replacing your Auth0, Okta, Firebase with hardened security and PassKeys, SMS, OIDC, Social Sign In, MFA, FIDO, TOTP and OTP, WebAuthn, passwordless and much more. Golang, headless, API-first. Available as a worry-free SaaS with the fairest pricing on the market!
macrobase-diff - Minimal implementation of Macrobase Diff
MLflow - Open source platform for the machine learning lifecycle
dbt-audit-helper - Useful macros when performing data audits
duf - Disk Usage/Free Utility - a better 'df' alternative