Scalefree's tool to automatically generate Data Vault models for the dbt package "datavault4dbt" based on metadata.

Use AWS Lambda to Pull E-Scooter and E-Bike Location Data, store in S3 & Redshift using Data Vault Data Model, Server to Google Data Studio Dashboard

Data Vault Modeling

An example Data Vault 2.0 data warehouse modelling Microsoft's Northwind sample database.

A charm to deploy and initialize Vault on Kubernetes and Machine models. Secure, store and tightly control access to tokens, passwords, certificates, encryption keys for protecting secrets and other sensitive data.

Data Vault data model and ETL generator for Oracle Databases

Dataform utility library that allow fast bootstrapping for data-vault model on bigquery

A concept and syntax to provide a universal data format, for storing all essential informations, that are needed to implement or generate a data loading process for a data vault model.

AI-powered MCP server for Chef-to-Ansible migration & Ansible upgrades: 48 tools for cookbook/Habitat conversion, InSpec to Testinfra, data bags to Vault, AWX/AAP workflows, CI/CD pipelines, upgrade planning & compatibility matrix validation. Model-agnostic. Web UI included.

A local regional bank, named MidWesTen Bank, has hired you to design and develop a simple banking software solution for them, which they will be using to run part of their banking business; specifically, the system will be used to collect, maintain and manage data about their customers and the bank accounts they operate. They want you to implement a basic web application for this purpose. Especially important to the Bank manager is, the data that provides information about the net liquidity of the bank, on any given day. The bank’s operational data model is given as follows: A Customer can own many Accounts. An Account belongs to just one Customer. An Account must be of one of many possible AccountTypes. The Bank currently offers the following 3 AccountTypes: 1. Checking account 2. Loan account 3. Savings account Your solution model should consist of the following three data entities: 1. Customer 2. Account 3. AccountType Here are the attributes for the entities: Customer: customerId:long, customerNumber:long, firstName:string, middleName:string, lastName:string, emailAddress:string, contactPhoneNumber:string, dateOfBirth:date Account: accountId:long, accountNumber:long, balance (Note: the account balance represents the amount of money in dollars and cents held in the account) AccountType: accountTypeId:int, accountTypeName:string Here are excerpts of the Bank’s existing data, which you are expected to input into the new banking software system: AccountTypes: AT1: { accountTypeId:1, accountTypeName: Checking} AT2: { accountTypeId:2, accountTypeName: Loan} AT3: { accountTypeId:3, accountTypeName: Savings} Customers: C1: {customerId:1, customerNumber:10001, firstName:Anna, middleName:””, lastName:Smith, emailAddress:asmith@gmail.net, contactPhoneNumber:(641) 451-0001, dateOfBirth:1978-5-21} C2: {customerId:2, customerNumber:10002, firstName:Bob, middleName:Earl, lastName:Jones, emailAddress:bob.e.jones@earthlink.org, contactPhoneNumber:(319) 001-0001, dateOfBirth:1964-12-7} Accounts: A1: {accountId:1, accountNumber:100001, balance:$190,590.95} – belongs to customer, C1; This account is of the AccountType, Savings. A2: {accountId:2, accountNumber:100002, balance:$60,000.00} – belongs to customer, C1; This account is of the AccountType, Loan. A3: {accountId:3, accountNumber:100003, balance:$354,005.26} – belongs to customer, C2; This account is of the AccountType, Checking. For this question, you are required to do the following: 1. Draw a simple UML Static (class) model for the software solution. 2. Using the set of tools, technologies and frameworks which you have learnt about in this CS425 course, including Spring Boot Spring Web MVC, Spring Data JPA, etc., (or some other Enterprise Web application development platform/tool(s) that you prefer), implement a working web application for MidWesTen Bank. You may use any database of your choice. You are expected to implement only the following features and use-cases: 1. Display a homepage which presents a set of menu options. 2. Display list of Customers (Allows the bank manager to view a list of all the Customers registered in the system). The bank requires this list to be displayed sorted in ascending order of the Customers’ last names (see sample screen below). 3. Register a new Customer (Allows the bank manager to add a new Customer into the system). 4. Display list of Accounts (Allows the bank manager to view a list of all the Accounts held in the system). The bank requires this list to be displayed sorted in ascending order of the Account Number (see sample screen below). 5. Open a new Account (Allows the bank manager to add/open a new Account for an existing customer in the system). 6. Display the bank’s net liquidity position (This means the system presents to the bank manager, a computed value that represents the bank’s net liquidity. This value is computed by taking the sum of the Savings and Checking accounts balances minus the sum of the Loan accounts balances. It represents the total amount of cash expected in the bank’s vault). Your solution should display this data at the bottom of the “List of Accounts” table (see sample screen below). 7. Using the JUnit framework, write a Unit Test case for your function/method that computes the bank’s net liquidity. Be sure to execute your Test-case and take a screenshot of your result, as displayed by your IDE. Shown below are sample User Interfaces for the use-cases/tasks. Note: Your own UI design does NOT necessarily have to look exactly like these samples. But your UIs should contain all the necessary data and data fields, as shown.

Data Vault Model Materialisation Macros for dbt

This repo will contain DBT data models using data vault data modeling techniques.

Data access with Data Vault Modeling

The next-generation sovereign AI ecosystem. Mnemosyne Neural OS empowers users with multi-model agents, local-first data privacy, and an encrypted knowledge vault. Experience the future of private, autonomous edge-to-cloud R&D.

a personal data vault that keeps all your sensitive information (name, medical records, preferences, usage history, etc.) encrypted under your control. You hold the only keys to decrypt this data, much like having a private locker. When interacting with a Large Language Model (LLM) assistant.

TurboVault Engine is a CLI-first, Django-based engine that ingests source metadata (e.g. from Excel files or database tables), maps it into a Data Vault–oriented internal model, and generates a fully structured dbt project from it.

Auto-Vault represents a dataset cataloging the automotive field of the last four decades. It is a rich repository, featuring over 40,000 automobiles, encapsulating the essence of most models manufactured after 1983. The data was scraped using WebScraperV1 and contains information about each vehicle, like displacement, transmission type, etc.

Welcome to my collaborative development repository! This space is dedicated to fostering innovation, transparency, and efficiency in software development process. Here, we can leverage the power of Git and GitHub to create a seamless workflow for our team and community contributors.

Data Vault 2.0 made simple. This project uses a fashion retail example with dbt, PostgreSQL, and Grafana to explain hubs, links, satellites, PIT, and marts showing how Data Vault builds flexible, auditable, and scalable data warehouses.

Cross-platform application for modelling databases based on Data Vault architecture

This project is a Data Modeling Design and deployment using Data Vault 2.0 methodology for a Near Real Time vault.

publish subscribe model using SpringBoot (micro), Apache Kafka, Spring Data, Consul, Vault, Docker, Kubernetes

Trying to translate the book of "Building a Scalable Data Warehouse with Data Vault 2.0" to Chinese language to better understand this data modelling concept.

Working with SCD Type (Change Data Capture) and need a Data Vault model to test Azure Data Factory v2? - This Code with Help!

This project builds a modern, scalable data warehouse architecture using: AWS Aurora Serverless, AWS Glue & Iceberg, DBT, Data Vault 2.0 modeling, Amazon Athena, Snowflake and Terraform

Data-driven strategy meets technical execution. A master vault housing everything from foundational coursework, predictive analytics/financial models, real-world consulting labs , and personal tech builds.

Data Vault model for analyzing the flight activity and reservation processes of a major airline company. Provides SQL scripts, queries, and reports for gaining insights into business operations and improving performance.

A comprehensive vault of notes and code snippets on SQL technologies—from raw SQL and SQLAlchemy Core to advanced ORMs and NoSQL tools like MongoDB. Ideal for backend development, data modeling, and database optimization.

Healthcare RCM Data Pipeline - Azure Data Engineering An end-to-end Azure Data Engineering pipeline for Healthcare Revenue Cycle Management (RCM) using Medallion Architecture (Bronze, Silver, Gold). It processes EMR, Claims, and ICD/CPT Codes with ADF, Databricks, Delta Lake, and Key Vault for SCD2, Fact & Dimension modeling, and KPI tracking.

Aegis Vault is an open-source, developer-first Python library that safeguards sensitive data in AI prompts. Built for legal, enterprise, and security-conscious environments, it detects and encrypts PII (like CPF, CNPJ, emails, IPs, etc.) in real time — before sending data to any large language model (LLM).