Skip to content
Get Started
Concepts
Using the App
Templates
Reference
Search
Ctrl
K
Cancel
Getting Started
What is ADL?
Quick Start Guide
Concepts
How ADL Works
Metadata & Data Objects
Templates & Code Generation
Conventions
Classifications
Personas
Perspectives
Extensions
Containment & Child Objects
Using the App
App UI
Home
Data Objects
Data Object Mappings
Connections
Templates
Code Generator
Code Preview
Conventions
Classifications
Metadata Health
Design
Files
Logs
Configuration
Profile
AI Assistant
Metadata Importer
Metadata Importer
Connections
Data Objects
Sample Connections
Sample Data Objects
Guides
Your First Project
Create a Custom Template
Import Existing Metadata
Templates
Overview
output-types
Overview
Data Definition Language (DDL)
Stored Procedure
View
allmetadata
All-metadata templates
Control Framework Registration
Control Framework Registration (v2)
Control Framework Start Queue
Control Framework Stop Queue
Documentation
Snowflake Deployment
SQL Server Deployment
dataobjectmappings
Documentation
integration
Integration mapping templates
Data Vault Hub Stored Procedure
Data Vault Hub View
Data Vault Link Satellite (Driving Key) Stored Procedure
Data Vault Link Satellite Driving Key View
Data Vault Link Satellite Stored Procedure
Data Vault Link Satellite View
Data Vault Link Stored Procedure
Data Vault Link View
Data Vault Satellite Stored Procedure
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
Data Vault Hub SQL Server Table
Data Vault Link SQL Server Table
Data Vault Satellite SQL Server Table
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
Handlebars Helpers
Overview
{{createDeterministicGuid}}
{{createGuid}}
{{Exists}}
{{*filter}}
{{hasClassification}}
{{hasClassificationGroup}}
{{hasStringValue}}
{{lookupConnection}}
{{lookupExtension}}
{{now}}
{{*order}}
{{randomdate}}
{{randomnumber}}
{{randomstring}}
{{replicate}}
{{space}}
{{stringcompare}}
{{stringdiff}}
{{stringLower}}
{{stringreplace}}
{{stringUpper}}
{{stringwrap}}
{{substring}}
{{targetDataItemExists}}
Sample Designs
Overview
Persistent Staging Area — Snowflake
Data Vault Physical Data Warehouse — SQL Server
Data Vault Virtual Data Warehouse — SQL Server
Persistent Staging Area — Microsoft Fabric (PySpark)
Persistent Staging Area — SQL Server
Willibald — SQL Server
Business Model
Metadata Architecture
NBility
Data Solution Automation Schema
Schema Reference
Schema Reference
Glossary
Terms & Policies
Account
Privacy Policy
Terms of Service
Documentation
Overview
Section titled “Overview”
Integration Layer data object creation templates.
