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
Auth0 for AI Agents now in GA
Connect your AI agents to apps and data more securely, give users control over the actions AI agents can perform and the data they can access, and enable human confirmation for critical agent actions.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of SQLBucket!
