SqlTask

SqlTask is an extensible ETL library based on SqlAlchemy to help build robust ETL pipelines with high emphasis on data quality.

Main features of SqlTask:

Create well documented data models that support iterative development of both schema and data transformation logic.
Tightly coupled data quality checking with transformation logic with automatic creation of visualization-friendly and actionable data quality tables.
Make use of SQL where practical, especially expensive data filtering and aggregation during data extraction.
Row-by-row data transformation using Python where SQL falls short, e.g. calling third party libraries or storing state from previous rows.
Encourage use of modern version control tools and processes, especially GIT.
Performant data uploading/insertion where supported.
Easy integration with modern ETL orchestration tools, especially Apache Airflow.

Word of caution: SqlTask is currently under heavy development, and the API is expected to change frequently.

Supported databases

SqlTask supports all databases with a SqlAlchemy dialect, with dedicated support for the following engines:

Engines not listed above will fall back to using regular inserts.

To install SqlTask without any dependencies, simply run

pip install sqltask

To automatically pull in dependencies needed by Snowflake, type

pip install sqltask[snowflake]

Please refer to the documentation on Read The Docs for further information.

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution for sqltask 0.6.4.3
File	Size	Uploaded
sqltask-0.6.4.3.tar.gz	23.0 kB	Jan 24, 2020	Details

Download URL	sqltask-0.6.4.3.tar.gz
Size	23.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`79936d2955f21b0901df68282bc1699a87aaf5b6785d0627cb40375e002cb36b`
BLAKE2b-256 checksum How to use checksums	`0c4fe6583d3fa8f5ea528a4fdf5e6a839432f66e2f6395c76152238fb7261c18`
Upload date	Jan 24, 2020
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/2.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.2.0 requests-toolbelt/0.9.1 tqdm/4.36.1 CPython/3.7.4`