Download
SQLBucket is a lightweight framework to help write, orchestrate and validate SQL data pipelines. It gives the possibility to set variables and introduces some control flow using the fantastic Jinja2 library. It also implements a very simplistic unit and integration test framework where you can validate the results of your ETL in the form of SQL checks. With SQLBucket, you can apply TDD principles when writing data pipelines. To start working, you need to instantiate your SQLBucket core object with the project_folder parameter. That folder will contain all your SQL ETL. The python file where you create your SQLBucket object is also a good place to instantiate your command line interface.
Features
- An SQLBucket project is made of 3 core components: the configuration, the ETL queries and the integrity check queries
- The config.yaml is the core of your project
- ETL queries
- Integrity queries
- Install and update using pip
- It can work as a stand alone service, or be part of your workflow manager environment
Project Samples
Categories
Data QualityLicense
MIT LicenseFollow SQLBucket
Other Useful Business Software
One platform for global hiring and contractor management.
TFY unifies applicant tracking, team onboarding, compliance, contractor payments, and billing automation in a single, powerful platform, eliminating the need for multiple disconnected tools.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of SQLBucket!
