Data Vault Metadata Modelling with Biml
The companion walkthrough Auto Generate Data Vault using Biml shows how Biml generates a Data Vault model from source system metadata and a predefined pattern. Real Data Vault implementations rarely fit a single pattern, so the next step is to use Biml as a framework engine that an architect can customize to suit long term needs.
This webinar extends the auto-generation script to:
- Handle business keys explicitly rather than inferring them from primary keys.
- Split satellites by fast-changing attributes so volatile columns do not pollute slower-changing history.
- Define metadata for flat files alongside relational sources.
- Manually override any attribute that the metadata-driven defaults get wrong.
Watch the webinar on YouTube: Data Vault using Biml.
BimlStudio is required to test the code.
Downloads
- autogenerate-data-vault-part2-metadata.pptx is the slide deck used during the webinar.
- AutoGenerate_DV.zip contains the BimlStudio project demonstrated in the session.