---
title: Fabric Warehouse - Datamart
description: Fabric Warehouse - Datamart generates a Mart layer from the objects of linked projects, as T-SQL notebooks with a notebook load control.
---

[Skip to content](https://knowledge.bigenius-x.com/fabric-warehouse-datamart#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 - Datamart

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

Fabric Warehouse - Datamart generates a Mart layer from the objects of linked projects, as T-SQL notebooks with a notebook load control. Select the Generator Configuration `Fabric Warehouse DataMart` when you add a project whose data marts run in a Fabric Warehouse. This article lists what the configuration supports and where it differs from [Microsoft SQL Server - Datamart](https://knowledge.bigenius-x.com/microsoft-sql-server-datamart?hsLang=en).

[Mart Hierarchy Flatten](https://knowledge.bigenius-x.com/create-a-mart-hierachy-flatten?hsLang=en) 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." See [Model object type not supported on Fabric Warehouse (Business Rule)](https://knowledge.bigenius-x.com/model-object-type-not-supported-on-fabric-warehouse-business-rule?hsLang=en).

### Scope and output

- Platform: Microsoft Fabric Warehouse. The configuration is available since Generator 2.0.
- Layers: Mart, and the layers of the imported linked projects. Dataflow Modeling shows the imported objects in the Linked column in Silver and the Mart model objects in the Datamart column, which is Gold. 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?hsLang=en).

### Prerequisites

- A Fabric workspace with a warehouse for the Mart layer. The deployment notebooks switch to the existing warehouse with `USE` and create a missing schema; they create no warehouse.
- 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, schema, lakehouse, Key Vault and secret names are listed in [Fabric Warehouse - Placeholder values](https://knowledge.bigenius-x.com/fabric-warehouse-placeholder-values?hsLang=en).

### Sources and linked projects

The configuration reads only model objects of linked projects, for example of a Data Vault or Data Store project. It has no discovery of its own. [Import a linked project](https://knowledge.bigenius-x.com/import-a-project-to-be-used-as-a-linked-project?hsLang=en) before you model the Mart layer. You can also [export this project as a linked project](https://knowledge.bigenius-x.com/export-a-project-to-be-used-as-linked-project?hsLang=en).

Mart source views read the layers of the linked project as source systems, by three-part name with their own database and schema placeholders.

### Supported model objects

- [Mart Dimension](https://knowledge.bigenius-x.com/create-a-mart-dimension?hsLang=en)
- [Mart Fact](https://knowledge.bigenius-x.com/create-a-mart-fact?hsLang=en)
- [Mart Composite](https://knowledge.bigenius-x.com/create-a-mart-composite?hsLang=en)
- [Mart Out](https://knowledge.bigenius-x.com/create-a-mart-out?hsLang=en), since Generator 2.2

[Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en) offers these values:

- Mart Dimension: `Permanent` (default) or `Cached`
- Mart Fact: `FactLoadStrategy`
- Mart Composite and Mart Out: `Virtual` (default) or `Cached`

### Capabilities and limitations

- Keys: a Mart Dimension table has a primary key on its surrogate key and a unique constraint on its business key terms. A Mart Fact table has no primary key. All constraints are created as `NONCLUSTERED` and `NOT ENFORCED`.
- Foreign keys: [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) on Mart Fact offers `None` and `Create Disabled`, and the default is `Create Disabled`. `Create Disabled` creates the foreign keys to the Mart Dimensions as `NOT ENFORCED` constraints; `None` creates no constraint. `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. The Mart Dimension loader computes the surrogate key ([BG\_MartDimension\_Identity](https://knowledge.bigenius-x.com/bg_martdimension_identity?hsLang=en)) as the current maximum in the target plus `ROW_NUMBER()`.
- Unknown member: the deployment adds a row with the surrogate key -1 to each Mart Dimension table when the row is missing. [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en) sets its values.
- Change detection: [Delta Detection](https://knowledge.bigenius-x.com/delta-detection-model-object?hsLang=en) on the Mart Dimension sets how rows are compared; the default is `Hash Value Comparison`.
- 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?hsLang=en).
- Loading: [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) offers only `Multi-Threading Notebook`, a Python notebook that runs the loaders in dependency order. See [Fabric Warehouse - Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-warehouse-load-data-native-load-control?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

The configuration offers these project properties, with their defaults:

- [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en): `SHA1`; also `SHA2_256` and `MD5`
- [Hash Casing](https://knowledge.bigenius-x.com/hash-casing-project?hsLang=en): `None`; also `Upper` and `Lower`
- [Hash Concatenation Separator](https://knowledge.bigenius-x.com/hash-concatenation-separator-project?hsLang=en): `_`
- [Hash Null Placeholder](https://knowledge.bigenius-x.com/hash-null-placeholder-project?hsLang=en): `_NULL_`
- [Hash Trim](https://knowledge.bigenius-x.com/hash-trim-project?hsLang=en): 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](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en): on
- [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en): 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 - Datamart 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` |
| Surrogate key column | `INT`, set by the loader | `INT IDENTITY` |
| 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_UpdateTimestamp`, `BG_ValidFromTimestamp`, `BG_ValidToTimestamp`, `BG_EffectiveTimestamp`
- Row hashes: `BG_RowHash`, `BG_RowHashScd1`, `BG_RowHashScd2`
- Text, same lengths on both platforms: `BG_SourceSystem`, `BG_DataflowName`, `BG_DataflowSetName`, `BG_ErrorDescription`, `BG_IncrementLoadStatus`

### Example

A Mart Dimension `scd_0` with the business key term `CUSTOMER_ID` generates this table. The excerpt shows the example schema `mart` in place of the placeholder, leaves out eight columns and adds line breaks:

```
CREATE TABLE [mart].[DM_MD_scd_0] (
     [BG_SourceSystem] VARCHAR(255) NULL
    ,[BG_LoadTimestamp] DATETIME2(6) NOT NULL
    ,[scd_0_SK] INT NOT NULL
    ,[CUSTOMER_ID] INT NOT NULL
    ,[CUSTOMER] VARCHAR(100) NOT NULL
    ,[CUSTOMER_TYPE] VARCHAR(100) NOT NULL
)
;
ALTER TABLE [mart].[DM_MD_scd_0]
    ADD CONSTRAINT [PK_DM_MD_scd_0]
    PRIMARY KEY NONCLUSTERED ([scd_0_SK]) NOT ENFORCED;
ALTER TABLE [mart].[DM_MD_scd_0]
    ADD CONSTRAINT [UC_DM_MD_scd_0]
    UNIQUE NONCLUSTERED ([CUSTOMER_ID]) NOT ENFORCED;
```

The loader sets the values of the surrogate key `scd_0_SK`. With Microsoft SQL Server - Datamart, it is `INT IDENTITY`.

### Release differences

Project Settings shows the Generator Version of your project.

- Generator 2.0: first release of the configuration.
- Generator 2.2: Mart Out; the project properties Persist Validity, Create Result Views, Hash Casing, Hash Concatenation Separator, Hash Null Placeholder and Hash Trim; the model object property Increment Management Type on Mart Fact; the validation warnings `ID-35000` to `ID-35003`, including the Mart Hierarchy Flatten warning.
- Generator 2.3: the model object property Custom Singleton Values on Mart Dimension.

### Related articles

- Previous: [Import a Project to be used as a Linked Project](https://knowledge.bigenius-x.com/import-a-project-to-be-used-as-a-linked-project?hsLang=en) 
    - 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?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/fabric-warehouse-deployment?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-warehouse-load-data-native-load-control?hsLang=en)
- Reference: [Foreign Key Mode (Model Object)](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en), [Custom Singleton Values (Model Object)](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en), [Delta Detection (Model Object)](https://knowledge.bigenius-x.com/delta-detection-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), [BG\_MartDimension\_Identity](https://knowledge.bigenius-x.com/bg_martdimension_identity?hsLang=en), [Model object type not supported on Fabric Warehouse (Business Rule)](https://knowledge.bigenius-x.com/model-object-type-not-supported-on-fabric-warehouse-business-rule?hsLang=en) 
    - Fabric Warehouse: [Placeholder values](https://knowledge.bigenius-x.com/fabric-warehouse-placeholder-values?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), [Use Linked Projects](https://knowledge.bigenius-x.com/use-linked-projects?hsLang=en), [Microsoft SQL Server - Datamart](https://knowledge.bigenius-x.com/microsoft-sql-server-datamart?hsLang=en) 
    - Fabric Warehouse: [Data Store](https://knowledge.bigenius-x.com/fabric-warehouse-data-store?hsLang=en), [DataVault](https://knowledge.bigenius-x.com/fabric-warehouse-datavault?hsLang=en), [DataVault and Mart](https://knowledge.bigenius-x.com/fabric-warehouse-datavault-and-mart?hsLang=en), [Dimensional and Mart](https://knowledge.bigenius-x.com/fabric-warehouse-dimensional-and-mart?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)
    - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle)
    - [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