Overview

ADL ships with a collection of sample designs you can install from the Marketplace and inspect directly. Each one comes with pre-configured metadata, templates, and conventions for a common data solution pattern — pick a close match, then adapt it to your project.

For an overview of the starter-solutions story and why we ship them, see Features on the main site.

Available samples

Snowflake

• 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.
• Willibald: a Data Vault sample based on the community-known Willibald dataset, from two sources through landing and persistent staging into a virtualized integration layer.

Microsoft Fabric

• Persistent Staging Area (PSA) (preview): the PSA pattern adapted for PySpark notebooks on Microsoft Fabric.

Conceptual

• Business Model: core business entities and their relationships, for conceptual and business modeling.
• Metadata Architecture: a conceptual design example showing how to structure metadata for a data solution.
• NBility: a business capability reference model.
• Data Solution Automation Schema: models the underlying JSON schema ADL consumes, with templates that generate a runnable Starlight docs site.

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.