dv-generate

To generate Snowflake SQL DDL for a Data Vault model, you provide a validated vault construct to an automated generator. The tool orchestrates project settings and produces DDL, hash expressions, ghost records, and insert-only load patterns for hubs, links, and satellites.

An insert-only load pattern in Data Vault 2.0 is a data loading method that appends historical records without updating existing rows. This approach preserves historical accuracy across hubs, links, and satellites by enforcing append-only insert patterns.

Yes, you need a validated Data Vault construct before generating SQL. The generation process enforces a Doctrine gate that requires a pre-validated vault model to ensure structural integrity before producing DDL and load patterns.

Yes, you can configure hash algorithms and tenant settings for Data Vault SQL generation. The process gathers project-level settings including hash algorithm selection, Business Key Collision Code (BKCC), and tenant configuration to apply to the generated SQL artifacts.

You create ghost records for Data Vault hubs and links by running an automated SQL generator against a validated construct. The tool systematically produces DDL and ghost record expressions to initialize your hubs, links, and satellites.

A limitation of automated Data Vault SQL generation is its strict requirement for a pre-validated vault construct to pass the Doctrine gate. Without this validated input model, the generator cannot produce DDL or insert-only load patterns.