Skip to main content

diepvries

PyPI version shields.io PyPI license Build PRs Welcome

diepvries logo

Welcome to diepvries, a Python library to generate Data Vault SQL statements.

What does it do?

diepvries takes as input a Data Vault model (a list of hubs, links and satellites tables), and generates SQL statements to load data in those tables. For that purpose, it relies on naming conventions for tables and columns. There are 2 ways to feed a Data Vault model to diepvries:

  • Either declaratively, by enumerating tables and columns;
  • Or automatically, by building these structures using the database metadata.

At the moment, diepvries is only compatible with Snowflake.

diepvries works with Python 3.10 through 3.13.

Getting started

diepvries is distributed as a Python wheel on PyPI. In a virtual environment, you can grab the latest version by running:

pip install diepvries

and in a Python console:

from diepvries.hub import Hub
help(Hub)

If you see the help page for the Hub class, you're all set! :rocket:

Continue the journey

The best way to start using diepvries is by reading its documentation website. You'll find a tutorial, a list of naming conventions, and more!

Contributing

Want to fix a bug, improve the docs, or add a new feature? That's awesome! Please read the contributing document.

Changelog

You can find the changelog of this package in CHANGELOG.md.

Release files for diepvries 2.1.0

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

Source distribution (sdist)

Source distribution for diepvries 2.1.0
File Size Uploaded
diepvries-2.1.0.tar.gz 101.3 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for diepvries 2.1.0
File Interpreter ABI Platform
diepvries-2.1.0-py3-none-any.whl Python 3 none any Details

Total release size: 134.2 kB

Release files / diepvries-2.1.0.tar.gz

Download URL diepvries-2.1.0.tar.gz
Size 101.3 kB
Tags Source
SHA-256 checksum
How to use checksums
f8ca24084ef22f58878fb17cdd8f587931c7d933220ed0e0c148cd2737a9f3d2
BLAKE2b-256 checksum
How to use checksums
b1a09ce9f8d0e7d51a6ddd21c1c8b09afd986551506a4984e9a6a7c406bc5adb
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.10.20

Release files / diepvries-2.1.0-py3-none-any.whl

Download URL diepvries-2.1.0-py3-none-any.whl
Size 32.9 kB
Tags Python 3
SHA-256 checksum
How to use checksums
29cf54c65c95b4fc92428c6eda824bda53c36e938503f845a8d315cff06222b7
BLAKE2b-256 checksum
How to use checksums
409a9df39a37eb89b06282e12676039bb0070c205ee6721d035000a845b38e55
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.10.20

Release history Release notifications | RSS feed

This release

2.1.0 This release

2 release files

2.0.0

2 release files

1.0.1

2 release files

1.0.0

2 release files

0.9.1

2 release files

0.9.0

2 release files

0.8.0

2 release files

0.7.0

2 release files

0.6.4

2 release files

0.6.3

2 release files

0.6.2

2 release files

0.6.1

2 release files

0.6.0

2 release files

0.5.2

2 release files

0.5.1

2 release files

0.5.0

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page