Data Vault 2.0 scaffolding tool
Project description
Note: MSSQL and Postgres badges are generated by the
badgesCI job and pushed to thebadgesbranch.
Data Vault 2.0 scaffolding tool
:warning: Pre-alpha version disclaimer Please note that this package is in a pre-alpha version which means it is used internally in a small circle of users and backwards-incompatible changes might be introduced in future releases.
This tool is designed to streamline the process of creating Data Vault 2.0 entities, such as hubs, links, and satellites.
As well as building information layer objects such as dim and fact tables from a multidimensional paradigm.
How it works
User: provides a staging view stg.[entity_name] (or a table if the staging layer persisted)
with all requirements for the [entity_name] defined in the schema (how to define see below).
Tool:
- Validates metadata of the provided staging view or table.
- Generates the necessary DDL statements to create the Data Vault 2.0 entities.
- Generates ELT procedures to load data to the generated entities.
- Generates support procedures such as
meta.Drop_all_related_to_[entity_name]andelt.Run_all_related_to_[entity_name]
Installation
You can install sandwich via pip:
pip install sandwich
Usage example
For more examples and detailed usage, please refer to the documentation.
Contributing
Contributions are welcome! If you have suggestions, feature requests, or find any bugs, please open an issue or submit a pull request. Make sure to follow the contribution guidelines.
Acknowledgments
This project is inspired by the beauty of the Data Vault 2.0 methodology.
License
This project is licensed under the MIT License.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file sandwich-0.6.0.tar.gz.
File metadata
- Download URL: sandwich-0.6.0.tar.gz
- Upload date:
- Size: 18.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.10.4 {"installer":{"name":"uv","version":"0.10.4","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Debian GNU/Linux","version":"13","id":"trixie","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
baf01bb9d7a426a30ed48410267b858edad33b4369719b4a29e27d32baff0692
|
|
| MD5 |
d24911f0eb9970e62936694a621f2dc5
|
|
| BLAKE2b-256 |
5cab209f8241b0d00f9df845c2803cc5cd1345f7c9e9b00af65ea62502016518
|
File details
Details for the file sandwich-0.6.0-py3-none-any.whl.
File metadata
- Download URL: sandwich-0.6.0-py3-none-any.whl
- Upload date:
- Size: 34.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.10.4 {"installer":{"name":"uv","version":"0.10.4","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Debian GNU/Linux","version":"13","id":"trixie","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
d7ca58d759728e919d8c76f82644cdfc61e77a5844d5ccd828ee46af5a201ed3
|
|
| MD5 |
6ce7c80cd430c3ce2fb66f26678ad15e
|
|
| BLAKE2b-256 |
d470fac032ff46a399502c4b2c229ac965b895855b1561facdfe72c1ba3007d9
|
