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

• 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.

Microsoft Fabric

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

Conceptual

• 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.