Skip to content
ADL Docs
Get Started
Concepts
Using the App
Templates
Reference
Search
Ctrl
K
Cancel
Select theme
Dark
Light
Auto
Getting Started
What is ADL?
Quick Start Guide
Concepts
How ADL Works
Metadata & Data Objects
Templates & Code Generation
Naming Conventions
Classifications
Using the App
App UI
Home
Data Objects
Data Object Mappings
Connections
Templates
Code Generator
Code Preview
Conventions
Classifications
CAT Scan
Graph
Files
Logs
Metadata Importer
Metadata Importer
Connections
Data Objects
Sample Connections
Sample Data Objects
Guides
Your First Project
Create a Custom Template
Import Existing Metadata
Templates
allmetadata
Documentation
Control Framework Registration
Documentation
Snowflake Deployment
SQL Server Deployment
dataobjectmappings
Documentation
integration
Documentation
Data Vault Hub View
Data Vault Link Satellite Driving Key View
Data Vault Link Satellite View
Data Vault Link View
Data Vault Satellite View
staging
Staging
Landing Area Stored Procedure Delta
Landing Area Stored Procedure Delta
Landing Area Stored Procedure Delta
Persistent Staging Area Stored Procedure Delta
Persistent Staging Area Stored Procedure Delta
Persistent Staging Area Stored Procedure Full Outer Join
dataobjects
integration
Integration Layer data object creation templates
staging
Staging
Landing Area Snowflake Table
Landing Area SQL Server Table
PSA Snowflake Table
PSA Snowflake User Managed Table
PSA SQL Server Table
PSA SQL Server User Managed Table
Source Snowflake Table
Source SQL Server Table
extensions
Has Control Framework extension
nometadata
Sample Data Snowflake
Sample Data SQL Server
Sample Data User Managed SQL Server
output-types
Data Definition Language (DDL)
Stored Procedure
View
Handlebars Helpers
{{Exists}}
{{lookupExtension}}
{{now}}
{{randomdate}}
{{randomnumber}}
{{randomstring}}
{{replicate}}
{{space}}
{{stringcompare}}
{{stringdiff}}
{{stringreplace}}
{{stringwrap}}
{{targetDataItemExists}}
Sample Designs
Overview
Data Vault Virtual Data Warehouse — Snowflake
Persistent Staging Area — Snowflake
Data Vault Physical Data Warehouse — SQL Server
Data Vault Virtual Data Warehouse — SQL Server
Persistent Staging Area — SQL Server
Metadata Architecture
NBility
Schema Reference
DwaModel
BusinessKeyDefinition
Cardinality
CardinalityRange
DataClassification
DataConnection
DataItem
DataItemMapping
DataItemQuery
DataObject
DataObjectMapping
DataObjectMappingList
DataObjectQuery
Extension
IDataItem
IDataObject
IMetadata
Relationship
Utils
DefaultJsonOptions
HandlebarsHelpers
JsonValidation
ValidationResult
UtilityFunctions
Glossary
Terms & Policies
Account
Privacy Policy
Terms of Service
Select theme
Dark
Light
Auto
Documentation
Overview
Section titled “Overview”
Templates that access all metadata.