Overview

Starting a data solution from scratch can feel overwhelming. ADL makes it easier by providing ready-made sample designs that you can explore, learn from, and build on.

Each sample comes with pre-configured metadata, templates, and conventions for a common data solution pattern. Pick one that’s close to what you need, and customize it from there.

Available samples

Snowflake

• Data Vault Virtual Data Warehouse — A Data Vault architecture on Snowflake with views-based integration and presentation layers.
• Persistent Staging Area (PSA) — A staging pattern with delta detection, adapted for Snowflake.

SQL Server

• Data Vault Physical Data Warehouse — A Data Vault architecture with physically materialized tables on SQL Server.
• Data Vault Virtual Data Warehouse — A 3-tiered Data Vault solution with views-based integration and presentation layers.
• Persistent Staging Area (PSA) — A staging pattern with delta detection using stored procedures on SQL Server.

Conceptual

• Metadata Architecture — A conceptual design example showing how to structure metadata for a data solution.
• NBility — A business capability reference model.

Using a sample

1. Choose Start New Project from the Home screen.
2. Set up your project folders and connect to a local folder.
3. In the Select Initial Content step, choose Sample Solution and pick the one you want.
4. For each sample, you can choose to include metadata, templates, or both.
5. ADL creates all the files and loads them into the app.

See the Getting Started guide for the full walkthrough.