---
title: Fabric Warehouse - DataVault
description: Fabric Warehouse - DataVault generates a Stage, Raw Vault and Business Vault for Fabric Warehouse as T-SQL notebooks with a notebook load control.
---

[Skip to content](https://knowledge.bigenius-x.com/fabric-warehouse-datavault-2.0#main-content)

[Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en)

[![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/)

Open main navigation

Close main navigation

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new)
- [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en)
2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en)
3. [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)

# Fabric Warehouse - DataVault

**Applies to**  
Platform: Fabric Warehouse  
Architecture: Data Vault

Fabric Warehouse - DataVault generates a Stage, Raw Vault and Business Vault for Fabric Warehouse as T-SQL notebooks with a notebook load control. Select it in Project Settings, where Generator Configuration shows `Fabric Warehouse DataVault`, when your Data Vault runs in a Fabric Warehouse. This article lists what the configuration supports and where it differs from [Microsoft SQL Server - DataVault](https://knowledge.bigenius-x.com/microsoft-sql-server-datavault-2.0?hsLang=en).

Hierarchy Flatten is not supported on Fabric Warehouse and is missing from the model object list below. For a model object of this type, validation reports warning `ID-35003`: "Fabric Warehouse uses Synapse SQL, which currently does not support the required recursive common table expressions."

### Scope and output

- Platform: Microsoft Fabric Warehouse. The configuration is available since Generator 2.0.
- Layers: Source, Stage, Raw Vault and Business Vault. Dataflow Modeling shows Stage in the Bronze column and both vault layers in the Silver column. See [Understand the Layering concept](https://knowledge.bigenius-x.com/understand-the-layering-concept?hsLang=en).
- Output: T-SQL deployment notebooks, a deployment pipeline definition and Python load control notebooks, described in [Fabric Warehouse - Artifacts](https://knowledge.bigenius-x.com/fabric-warehouse-artifacts-2.0?hsLang=en).

### Prerequisites

- A Fabric workspace with a warehouse for the target layers. The deployment scripts switch to the existing database with `USE` and create missing schemas; they create no database.
- A lakehouse for the load control execution log. The load control deployment notebook creates the log as a Delta table there.
- An Azure Key Vault with the tenant ID, client ID and client secret of a service principal. The load control notebook uses them to connect to the warehouse.

A setup example is in [Fabric Warehouse - Target environment](https://knowledge.bigenius-x.com/fabric-warehouse-target-environment?hsLang=en). The placeholders for the warehouse, lakehouse, Key Vault and secret names are listed in [Fabric Warehouse - Placeholder values](https://knowledge.bigenius-x.com/fabric-warehouse-placeholder-values-2.0?hsLang=en).

### Sources and linked projects

Stage source views read each source table by its three-part name `[<database>].[<schema>].[<table>]`. The source system has the type `Microsoft Fabric Warehouse`, and its database and schema names are placeholders that you fill in when you replace the placeholders. The supported discovery types are listed in [Source Systems per Generator Configurations](https://knowledge.bigenius-x.com/source-systems-per-generator-configurations?hsLang=en).

You can [import a linked project](https://knowledge.bigenius-x.com/import-a-project-to-be-used-as-a-linked-project?hsLang=en) as a source and [export this project as a linked project](https://knowledge.bigenius-x.com/export-a-project-to-be-used-as-linked-project?hsLang=en).

### Supported model objects

#### Source and Stage

- [Source](https://knowledge.bigenius-x.com/create-a-source?hsLang=en)
- [Stage](https://knowledge.bigenius-x.com/create-a-stage?hsLang=en)

#### Raw Vault

- [Hub](https://knowledge.bigenius-x.com/create-a-hub?hsLang=en)
- [Link](https://knowledge.bigenius-x.com/create-a-link?hsLang=en)
- [Satellite](https://knowledge.bigenius-x.com/create-a-satellite?hsLang=en)
- [Link Satellite](https://knowledge.bigenius-x.com/create-a-link-satellite?hsLang=en)
- [Multi-Active Satellite](https://knowledge.bigenius-x.com/create-a-multi-active-satellite?hsLang=en)
- [Same As Link](https://knowledge.bigenius-x.com/create-a-same-as-link?hsLang=en)
- [Hierarchical Link](https://knowledge.bigenius-x.com/create-a-hierachical-link?hsLang=en)
- [Driving Key Link](https://knowledge.bigenius-x.com/create-a-driving-key-link?hsLang=en)
- [Record Tracking Satellite](https://knowledge.bigenius-x.com/create-a-record-tracking-satellite?hsLang=en)
- [Effectivity Satellite](https://knowledge.bigenius-x.com/create-an-effectivity-satellite?hsLang=en)
- [Record Tracking Link Satellite](https://knowledge.bigenius-x.com/create-a-record-tracking-link-satellite?hsLang=en)
- [Effectivity Link Satellite](https://knowledge.bigenius-x.com/create-an-effectivity-link-satellite?hsLang=en)
- [Non-Historized Link Satellite](https://knowledge.bigenius-x.com/create-a-non-historized-link-satellite?hsLang=en)
- Non-Historized Satellite (no article yet), since Generator 2.4
- [PIT](https://knowledge.bigenius-x.com/create-a-pit?hsLang=en)
- [Reference Table](https://knowledge.bigenius-x.com/create-a-reference-table?hsLang=en)
- [RawVault Composite](https://knowledge.bigenius-x.com/create-a-raw-vault-composite?hsLang=en)
- [Current View](https://knowledge.bigenius-x.com/create-a-current-view?hsLang=en)
- [History View](https://knowledge.bigenius-x.com/create-a-history-view?hsLang=en)

#### Business Vault

- [Business Hub](https://knowledge.bigenius-x.com/create-a-business-hub?hsLang=en)
- [Business Link](https://knowledge.bigenius-x.com/create-a-business-link?hsLang=en)
- [Business Satellite](https://knowledge.bigenius-x.com/create-a-business-satellite?hsLang=en)
- [Business Link Satellite](https://knowledge.bigenius-x.com/create-a-business-link-satellite?hsLang=en)
- [Same As Business Link](https://knowledge.bigenius-x.com/create-a-same-as-business-link?hsLang=en)
- [Hierarchical Business Link](https://knowledge.bigenius-x.com/create-a-hierarchical-business-link?hsLang=en)
- Business Driving Key Link (no article yet)
- [Effectivity Business Satellite](https://knowledge.bigenius-x.com/create-an-effectivity-business-satellite?hsLang=en)
- [Record Tracking Business Link Satellite](https://knowledge.bigenius-x.com/create-a-record-tracking-business-link-satellite?hsLang=en)
- [Effectivity Business Link Satellite](https://knowledge.bigenius-x.com/create-an-effectivity-business-link-satellite?hsLang=en)
- [Non-Historized Business Link Satellite](https://knowledge.bigenius-x.com/create-a-non-historized-business-link-satellite?hsLang=en)
- Non-Historized Business Satellite (no article yet), since Generator 2.4
- [Business PIT](https://knowledge.bigenius-x.com/create-a-business-pit?hsLang=en)
- [BusinessVault Composite](https://knowledge.bigenius-x.com/create-a-business-vault-composite?hsLang=en)
- [Business Current View](https://knowledge.bigenius-x.com/create-a-business-current-view?hsLang=en)
- [Business History View](https://knowledge.bigenius-x.com/create-a-business-history-view?hsLang=en)
- [Vault Out](https://knowledge.bigenius-x.com/create-a-vault-out?hsLang=en), since Generator 2.2

### Capabilities and limitations

- Keys: primary keys, unique constraints and foreign keys are created as `NONCLUSTERED` and `NOT ENFORCED`. [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) offers `None` and `Create Disabled`, and the default is `Create Disabled`. `Create Enforced` is not available.
- Indexes: index management is not available, and the generated tables have no indexes.
- Identity values: the tables have no `IDENTITY` columns. A loader computes identity values such as `BG_ID` as the current maximum in the target plus `ROW_NUMBER()`.
- Deployment: a deployment notebook holds at most the number of objects set in [Notebook Deployment Objects Limit](https://knowledge.bigenius-x.com/notebook-deployment-objects-limit-project?hsLang=en); further objects go to the next notebook. The pipeline definition runs the load control deployment first, then the deployment notebooks in order. See [Fabric Warehouse - Deployment](https://knowledge.bigenius-x.com/fabric-warehouse-deployment-2.0?hsLang=en).
- Loading: [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) offers only `Multi-Threading Notebook`. This native load control of Fabric Warehouse is a Python notebook that runs the loaders in dependency order. Apache Airflow is not available. See [Fabric Warehouse - Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-warehouse-load-data-native-load-control-2.0?hsLang=en).
- Data types: validation reports warning `ID-35000` when the length, precision or scale of a term does not fit its Fabric Warehouse data type. Warning `ID-35001` flags a business key term of type `varchar(max)` or `varbinary(max)`, because constraints on it could block the deployment.

### Project properties

Project Settings shows these properties of the configuration, with their defaults:

- [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en): `SHA1`; also `SHA2_256` and `MD5`
- Hash Casing: `None`; also `Upper` and `Lower`
- Hash Concatenation Separator: `_`
- Hash Null Placeholder: `_NULL_`
- Hash Trim: off
- [Begin of Universe](https://knowledge.bigenius-x.com/begin-of-universe-project?hsLang=en): `19000101`
- [End of Universe](https://knowledge.bigenius-x.com/end-of-universe-project?hsLang=en): `99991231`
- Persist Validity: on
- Create Result Views: on
- [Configure LoadControl](https://knowledge.bigenius-x.com/configure-loadcontrol-project?hsLang=en): on
- [Deploy LoadControl](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en): on
- [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en): `Multi-Threading Notebook`
- [Notebook Deployment Objects Limit](https://knowledge.bigenius-x.com/notebook-deployment-objects-limit-project?hsLang=en): `100`
- [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en): `Generate Drop Table Statements`

### Platform differences

The table compares the configuration with Microsoft SQL Server - DataVault of the same release:

| Item | Fabric Warehouse | Microsoft SQL Server |
| --- | --- | --- |
| Timestamp Default Terms | `datetime2(6)` | `datetimeoffset` |
| Hash Default Terms | `varbinary(20)` | `binary(20)` |
| Text Default Terms | `varchar` | `nvarchar` |
| Persist Validity default | on | off |
| Enforced foreign keys | not available | available |
| Index management | not available | available |
| Artifact Output Mode | not available | available |
| Target Object Comment Type | not available | available |

LoadControl Options offers `Multi-Threading Notebook` on Fabric Warehouse and `Native Load Control` or `Airflow` on Microsoft SQL Server. Notebook Deployment Objects Limit exists only on Fabric Warehouse.

These Default Terms belong to each group:

- Timestamps: `BG_LoadTimestamp`, `BG_ValidFromTimestamp`, `BG_ValidToTimestamp`, `BG_UpdateTimestamp`, `BG_EffectiveTimestamp`, `DVPIT_ForeignKey_LoadDate`
- Hash keys and row hashes: `Hub_HK`, `Link_HK`, `DrivingKeyLink_HK`, `PIT_HK`, `DVLINK_ForeignKey_Identity`, `DVPIT_ForeignKey_Identity`, `BG_RowHash`, `BG_RowHashScd1`, `BG_RowHashScd2`
- Text, same lengths on both platforms: `BG_SourceSystem`, `BG_DataflowName`, `BG_DataflowSetName`, `BG_ErrorDescription`, `BG_IncrementLoadStatus`

### Example

A Hub `common_customer` with the business key term `CUSTOMER_ID` generates this table. The excerpt shows the example schema `rdv` in place of the placeholder and adds line breaks:

```
CREATE TABLE [rdv].[RDV_HUB_common_customer] (
     [BG_LoadTimestamp] DATETIME2(6) NOT NULL
    ,[Hub_HK] VARBINARY(20) NOT NULL
    ,[BG_SourceSystem] VARCHAR(255) NULL
    ,[CUSTOMER_ID] INT NOT NULL
)
;
ALTER TABLE [rdv].[RDV_HUB_common_customer]
    ADD CONSTRAINT [PK_RDV_HUB_common_customer]
    PRIMARY KEY NONCLUSTERED ([Hub_HK]) NOT ENFORCED;
ALTER TABLE [rdv].[RDV_HUB_common_customer]
    ADD CONSTRAINT [UC_RDV_HUB_common_customer]
    UNIQUE NONCLUSTERED ([CUSTOMER_ID]) NOT ENFORCED;
```

With Microsoft SQL Server - DataVault, the three Default Terms of this Hub get the types `datetimeoffset`, `binary(20)` and `nvarchar(255)`.

### Release differences

Project Settings shows the Generator Version of your project.

- Generator 2.0: first release of the configuration.
- Generator 2.2: Vault Out; the project properties Persist Validity, Create Result Views, Hash Casing, Hash Concatenation Separator, Hash Null Placeholder and Hash Trim; the model object properties Increment Management Type and Use Embryo Loader; the validation warnings `ID-35000` to `ID-35003`, including the Hierarchy Flatten warning.
- Generator 2.3: the model object properties Custom Singleton Values and Excluded from Delta Detection.
- Generator 2.4: Non-Historized Satellite and Non-Historized Business Satellite.

### Related articles

- Previous: 
    - Fabric Warehouse: [Target environment](https://knowledge.bigenius-x.com/fabric-warehouse-target-environment?hsLang=en)
- Next: [Generate artifacts](https://knowledge.bigenius-x.com/generate-artifacts?hsLang=en), [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en) 
    - Fabric Warehouse: [Artifacts](https://knowledge.bigenius-x.com/fabric-warehouse-artifacts-2.0?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/fabric-warehouse-deployment-2.0?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-warehouse-load-data-native-load-control-2.0?hsLang=en)
- Reference: [Foreign Key Mode (Model Object)](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en), [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en), [Notebook Deployment Objects Limit (Project)](https://knowledge.bigenius-x.com/notebook-deployment-objects-limit-project?hsLang=en), [Deployment Options (Project)](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en) 
    - Fabric Warehouse: [Placeholder values](https://knowledge.bigenius-x.com/fabric-warehouse-placeholder-values-2.0?hsLang=en)
- See also: [Available Generator Configurations](https://knowledge.bigenius-x.com/available-generator-configurations?hsLang=en), [Understand the Generator Configuration](https://knowledge.bigenius-x.com/understand-the-generator-configuration?hsLang=en), [Source Systems per Generator Configurations](https://knowledge.bigenius-x.com/source-systems-per-generator-configurations?hsLang=en), [Push view to repo (Project)](https://knowledge.bigenius-x.com/push-view-to-repo-project?hsLang=en) 
    - Fabric Warehouse: [DataVault and Mart](https://knowledge.bigenius-x.com/fabric-warehouse-datavault-and-mart-2.0?hsLang=en)

- [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content)

    - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines)
    - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working)
    - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account)
- [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en)
- [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en)
- [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content)

    - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration)
    - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions)
    - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features)
    - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects)
    - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches)
    - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections)
    - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview)
    - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps)
    - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms)
    - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping)
    - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships)
    - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality)
    - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes)
    - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling)
    - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts)
    - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings)
    - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace)
- [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content)

    - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)
    - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse)
    - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)
    - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake)
    - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server)
    - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts)
    - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders)
    - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)
    - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment)
    - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline)
    - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment)
    - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment)
    - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)
    - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)
    - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type)
    - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties)
    - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms)
- [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content)

    - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations)
- [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content)

    - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches)
    - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases)
    - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules)
    - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules)
- [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en)
- [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content)

    - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application)
    - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application)
    - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators)
- [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content)

    - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs)
    - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits)

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en)
- [Customer Portal](https://knowledge.bigenius-x.com/customer-portal)
- [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login)

[![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG