sqlleaf
Trace your data
sqlleaf is a tool to help you to understand how your data flows across your data systems by producing detailed, column-level lineage across any SQL query and dialect.
Example
-- File: example.sql
CREATE TABLE users (name VARCHAR(50), birthday DATE);
CREATE TABLE logins (name VARCHAR(50));
INSERT INTO users (name, birthday)
SELECT LOWER(name) AS name, CURRENT_TIMESTAMP AS birthday
FROM logins;
sql = open("example.sql").read()
import sqlleaf
lineage = sqlleaf.Lineage()
lineage.generate(sql=sql, dialect="postgres")
lineage.print_paths()
Output:
column[logins.name] -> function[LOWER] -> column[users.name]
function[CURRENT_TIMESTAMP] -> column[users.birthday]
Development
This project is under heavy development; version 0.1 will be released soon.
1 maintainer
Metadata
1 maintainer
Release files for sqlleaf 0.0.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| sqlleaf-0.0.1.tar.gz | 113.1 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlleaf-0.0.1-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 265.9 kB
Release files / sqlleaf-0.0.1.tar.gz
| Download URL | sqlleaf-0.0.1.tar.gz |
|---|---|
| Size | 113.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
8745b5dbe8e49728aac34cb6e02e2c86898d7adba5468f1abae311ddfb166390
|
|
BLAKE2b-256 checksum How to use checksums |
fba47444f9bf56da96759242330719801213d08efa672ad27992e310c9073456
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.0
|
Release files / sqlleaf-0.0.1-py3-none-any.whl
| Download URL | sqlleaf-0.0.1-py3-none-any.whl |
|---|---|
| Size | 152.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
e4d210a5412e9aa8cd8aeaecd326ac0377a4958e112f035cbac9f3fbf61f4195
|
|
BLAKE2b-256 checksum How to use checksums |
804257a00058ccade89f4db0ef06af0d2baa09b4ce748b395baaf138cfe6cc97
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.0
|
Security for sqlleaf 0.0.1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
