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
Naming Conventions
Classifications
Personas
Perspectives
Extensions
Using the App
App UI
Home
Data Objects
Data Object Mappings
Connections
Templates
Code Generator
Code Preview
Conventions
Classifications
Graph
Files
Logs
Configuration
Profile
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
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
output-types
Data Definition Language (DDL)
Stored Procedure
View
Handlebars Helpers
Overview
{{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 — Microsoft Fabric (PySpark)
Persistent Staging Area — SQL Server
Metadata Architecture
NBility
Data Solution Automation Schema
Schema Reference
Schema Reference
Glossary
Terms & Policies
Account
Privacy Policy
Terms of Service
Staging
Overview
Section titled “Overview”
Staging Layer data object creation templates.
