bi_etl Python ETL Framework for BI
Docs
Please see the documentation site for detailed documentation.
Python based ETL (Extract Transform Load) framework geared towards BI databases in particular. The goal of the project is to create reusable objects with typical technical transformations used in loading dimension tables.
Guiding Design Principles
-
Don’t Repeat Yourself (DRY).
-
The source or target of an ETL owns the metadata (list of columns and data types). The ETL generally has no reason to define those again unless the ETL requires a change. If a datatype must be changed, only that one column’s new type should be specified. If a column name must be changed, only the source & target column names that differ should be specified.
-
Data Quality is King
-
Data quality is more important than performance. For example, the process should fail before truncating data contents (i.e. loading 6 characters into a 5 character field) even if that means sacrificing some load performance.
-
Give helpful error messages.
-
Make it as easy as possible to create re-usable modules.
-
SQL is a very powerful transformation language. The Transform Extract Load (TEL) model should be supported.
1 maintainer
Release files for bi_etl 1.9.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| bi_etl-1.9.3.tar.gz | 316.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| bi_etl-1.9.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 576.7 kB
Release files / bi_etl-1.9.3.tar.gz
| Download URL | bi_etl-1.9.3.tar.gz |
|---|---|
| Size | 316.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
4cb91c630725f02aa8a7c6218a30ff0ae54f62c7a8c2bf670a8b58be876be097
|
|
BLAKE2b-256 checksum How to use checksums |
cedb1cf52d3da6a1d82bad857699c83745abcc720f103dc201e7f8be39578589
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.11.18 {"installer":{"name":"uv","version":"0.11.18","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
|
Release files / bi_etl-1.9.3-py3-none-any.whl
| Download URL | bi_etl-1.9.3-py3-none-any.whl |
|---|---|
| Size | 260.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
51551295dfc4a4d22bdf01374a26e43543b7cbe7ed1ade1fa422e699efaaf3fb
|
|
BLAKE2b-256 checksum How to use checksums |
ed5714bc6c99f5294496490ff6d50f1b03b46eebcdd6944811439092ff289593
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.11.18 {"installer":{"name":"uv","version":"0.11.18","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
|
