zdbc
elementary
zdbc | elementary | |
---|---|---|
5 | 30 | |
2 | 1,739 | |
- | 1.7% | |
0.7 | 9.8 | |
about 1 year ago | 7 days ago | |
Java | HTML | |
Apache License 2.0 | 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.
zdbc
-
Best way to access SQL Server over the Internet.
OpenZiti could be the ticket, it's an open source solution that provides an overlay network built on zero trust principles (more secure than a VPN). Bonus, we took one of our SDKs and wrapped it around JDBC so that for users to access the DB, they do not need to have a VPN client; they just use 'ZDBC' instead of JDBC - https://github.com/openziti-test-kitchen/zdbc
-
How to connect to mysql server pod from external standalone application?
You can use agents or their ZDBC, which is one of the most amazing things (as they work with APIs you can embeded their SDK into your code, so no agents are required).
-
How to secure your Kubernetes cluster against attacks
- Example zitifications: https://github.com/openziti-test-kitchen/zdbc & https://openziti.github.io/articles/zitification/prometheus/part1.html
-
Clientless Private Access for Autonomous Database with no complexity of wallet or VPNs
Would be great to have thoughts, comments, etc - https://github.com/openziti-test-kitchen/zdbc or https://www.youtube.com/watch?v=H6o5z6iXYPQ&ab_channel=Percona
-
Launch HN: Metaplane (YC W20) – Datadog for Data
Congrats on the launch. Well done.
another security approach is to enable your customers to close their inbound firewall ports and link listeners. this helps cloud and on prem models have far stronger security.
example here (disclosure: i am a founder of the company behind this solution) with both open source and OEM/SaaS models:
https://github.com/openziti-incubator/zdbc (code for one implementation - a wrapper around the JDBC drivers)
https://netfoundry.io/zero-trust-database-security/ (blog post with links to developer example video, whitepaper, etc)
elementary
-
Open source data observability tools with UI?
Check out https://github.com/elementary-data/elementary
-
Data Validation tools
In this case, do https://github.com/elementary-data/elementary or https://greatexpectations.io help?
-
SQL “Visualization” Website/Resource?
That makes explain little easier to read. No graph though. Also https://github.com/elementary-data/elementary should know howto draw pretty graphs for data lineage ( ie. what columns comes where and is used how)
- Open source dbt tests monitoring
-
Suggestions for open source anomaly-detection, linting and metadata solutions?
there is elementary lineage / elementary-data which seems to be good try to solve those problem, i havent tested it well https://github.com/elementary-data/elementary
-
Snowflake SQL AST parser?
Some things you might be interested in are re_data and Elementary Data.
- Launch HN: Elementary (YC W22) – Open-source data observability
-
Data lineage info to a table in the DWH
Hi all, As part of building Elementary (open source data reliability), we implemented support of a new Snowflake feature (write operations in the access_history view). The change they made is most useful for understanding data lineage, which we solve (among other use cases :)).
-
Launch HN: Metaplane (YC W20) – Datadog for Data
I recently stumbled on an open-source tool with a similar premise: https://github.com/elementary-data/elementary-lineage
you can check it out
-
Lightweight data profiling tools / relationship discovery
Hi! we are working on an open source data lineage solution that might be helpful for your use case to learn the relationship between tables, we don't support column level just yet but we are working on it. Please let me know if we can help somehow and feel free to check it out here - https://github.com/elementary-data/elementary-lineage
What are some alternatives?
lightdash - Self-serve BI to 10x your data team ⚡️
re_data - re_data - fix data issues before your users & CEO would discover them 😊
DataProfiler - What's in your data? Extract schema, statistics and entities from datasets
sqllineage - SQL Lineage Analysis Tool powered by Python
Tailwind CSS - A utility-first CSS framework for rapid UI development.
dbt-data-reliability - dbt package that is part of Elementary, the dbt-native data observability solution for data & analytics engineers. Monitor your data pipelines in minutes. Available as self-hosted or cloud service with premium features.
superset - Apache Superset is a Data Visualization and Data Exploration Platform
tiddlywiki-docker - Tools for running TiddlyWiki via a Docker container
z_archived_kubectl - A zitified kubectl client. Archived in favor of the kubeztl repo jan-3-2023
dbt-core - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
deequ - Deequ is a library built on top of Apache Spark for defining "unit tests for data", which measure data quality in large datasets.