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
Go From AI Idea to AI App Fast
Access Gemini 3 and 200+ models. Build chatbots, agents, or custom models with built-in monitoring and scaling.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of SQLBucket!
