In this hands-on virtual tour recording, Patrick O’Halloran (Senior Solutions Architect, WhereScape) takes Data Vault from intimidating to intuitive; all in only 30 minutes.
Come learn with Patrick as he shows you how a simple, business-first model becomes a working Raw Vault: without hand-wiring hubs, links, or satellites.
You’ll see WhereScape 3D + RED turn rules and metadata into target-ready objects, ELT jobs and documentation.
What you’ll learn by watching:
- The blueprint: move from conceptual → logical → physical modeling, and why starting business-first avoids fragile “source-system modeling.”
- Source discovery & profiling: connect to databases, files, and APIs; derive relationships; use profiling stats (e.g., null percentages) to de-risk keys and data quality early.
- Rules in 3D: apply conventions, volatility, and PII handling once—let the rules engine propagate naming, types, validation, and repeatable patterns.
- One-click Data Vault generation: automatically produce hubs, links, and satellites from your logical design—and safely regenerate as requirements change.
- Load & stage automation: create EL pipelines and type-casting for your chosen target (Snowflake in the demo; also supports Fabric, Databricks, SQL Server, Oracle, Postgres & more).
- Orchestration in RED: generate ELT code, schedule parallel loads, set dependencies/retries, and monitor runs—without brittle scripting.
- Lineage & impact analysis: detect upstream schema drift and trace downstream effects before production breaks.
- Scale by example: watch ~11 source tables expand into 60+ managed objects in minutes—without manual wiring.
- Beyond the Raw Vault: quickly add PITs/Bridges and publish query-ready views that emulate facts/dimensions for analytics.
Recent Comments