--- title: Fabric Lakehouse Data Mart description: Fabric Lakehouse Data Mart generates a Mart layer from the objects of linked projects for Microsoft Fabric, as notebooks on Delta tables. --- [Skip to content](https://knowledge.bigenius-x.com/fabric-lakehouse-data-mart#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 Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) # Fabric Lakehouse Data Mart **Applies to** Platform: Fabric Lakehouse Architecture: Data Mart Fabric Lakehouse Data Mart generates a Mart layer from the objects of linked projects for Microsoft Fabric, as notebooks on Delta tables. Select the Generator Configuration `Fabric Lakehouse DataMart` when you add a project whose data marts run on Microsoft Fabric. With the project property [Target Platform](https://knowledge.bigenius-x.com/target-platform-project?hsLang=en) set to `Azure Synapse`, it generates for Azure Synapse Analytics instead. ### Scope and output - Platform: with [Target Platform](https://knowledge.bigenius-x.com/target-platform-project?hsLang=en) `Fabric`, the default, each layer is a schema of a Microsoft Fabric lakehouse. With `Azure Synapse`, each layer is a database in Azure Synapse Analytics, which the deployment creates with `CREATE DATABASE IF NOT EXISTS ... LOCATION`. - 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: notebooks in the folders `Jupyter`, `Helpers` and `LoadControl`, the notebook `_deploy` and, with Target Platform `Fabric`, `deploy.ps1`; described in [Fabric Lakehouse - Artifacts](https://knowledge.bigenius-x.com/fabric-lakehouse-artifacts?hsLang=en). ### Prerequisites - Target Platform `Fabric`: a Fabric workspace with a lakehouse with schemas. The deployment creates a schema per layer. - Target Platform `Fabric`: a service principal as Member of the workspace, and PowerShell 7 for `deploy.ps1`. - Target Platform `Azure Synapse`: an Azure Synapse workspace and a storage location per layer. The setup is described in [Fabric Lakehouse - Target environment](https://knowledge.bigenius-x.com/fabric-lakehouse-target-environment?hsLang=en) and [Azure Synapse - Target environment](https://knowledge.bigenius-x.com/azure-synapse-target-environment?hsLang=en), the placeholders in [Fabric Lakehouse - Placeholder values](https://knowledge.bigenius-x.com/fabric-lakehouse-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 with their own lakehouse and schema placeholders. ### Supported model objects - [Mart Dimension](https://knowledge.bigenius-x.com/mart-dimension?hsLang=en) - [Mart Fact](https://knowledge.bigenius-x.com/mart-fact?hsLang=en) - [Mart Composite](https://knowledge.bigenius-x.com/mart-composite?hsLang=en) - [Mart Hierarchy Flatten](https://knowledge.bigenius-x.com/mart-hierarchy-flatten?hsLang=en) - [Mart Out](https://knowledge.bigenius-x.com/mart-out?hsLang=en), since Generator 2.2 ### Capabilities and limitations - Loaders: one notebook per loader in the folder `Jupyter`, for example `DM_MD_bk_multipart_not_nullable_Loader`, with the load timestamp as the parameter `bg_loadtimestamp`. - Tables: Delta tables. [File Format](https://knowledge.bigenius-x.com/file-format-model-object?hsLang=en) offers only `delta`, and [Optimization Method](https://knowledge.bigenius-x.com/optimization-method-model-object?hsLang=en) offers `Partitioned By` and `Cluster By`. - Keys: the tables get no primary key, unique or foreign key constraints. [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) offers only `None`. - Indexes: index management is not available. - Surrogate keys: the loader computes `_sk` of a new row as a `Long` from the current time and `monotonically_increasing_id()`, without identity columns. - Unknown member: the deployment adds a row with the surrogate key `-1` to each Mart Dimension. [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en) sets its values. - Hashing: row hashes are `UNHEX(SHA2(..., 256))` in `Binary` columns, see [How biGENIUS-X builds hash values](https://knowledge.bigenius-x.com/how-bigenius-x-builds-hash-values?hsLang=en). - Validity: with Persist Validity on (default), historized tables store `bg_validtotimestamp`; off, the result view computes it. - Deployment: with the default [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), each deployment replaces the tables and the load control log tables with empty ones, see [Redeploy and keep data](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment?hsLang=en#redeploy-and-keep-data). With Target Platform `Fabric`, it also creates a schema per layer. - Loading: [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) offers `Multi-Threading Notebook` and `Airflow`. ### Project properties The configuration offers these project properties, with their defaults: - [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en): `SHA-256`, the only value - [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): `1900-01-01` - [End of Universe](https://knowledge.bigenius-x.com/end-of-universe-project?hsLang=en): `9999-12-31` - [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 - [Target Object Comment Type](https://knowledge.bigenius-x.com/target-object-comment-type-project?hsLang=en): `None`; also `Tables` and `Tables and Views` - [Target Platform](https://knowledge.bigenius-x.com/target-platform-project?hsLang=en): `Fabric`; also `Azure Synapse` - [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en): `Generate Drop Table Statements` and `Generate Create Schema If Not Exists Statements` - [Notebook Deployment Objects Limit](https://knowledge.bigenius-x.com/notebook-deployment-objects-limit-project?hsLang=en): `100` - [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`; also `Airflow` - [Logging Method](https://knowledge.bigenius-x.com/logging-method-project?hsLang=en): `Delta Table`; also `Python Logger` ### Data types The Default Terms get these data types: - Timestamps, `Timestamp`: `BG_LoadTimestamp`, `BG_UpdateTimestamp`, `BG_ValidFromTimestamp`, `BG_ValidToTimestamp`, `BG_EffectiveTimestamp` - Row hashes, `Binary`: `BG_RowHash`, `BG_RowHashScd1`, `BG_RowHashScd2` - Text, `String`: `BG_SourceSystem`, `BG_DataflowName`, `BG_DataflowSetName`, `BG_ErrorDescription`, `BG_IncrementLoadStatus` - Numbers, `Long`: `BG_ID`, `BG_DataQuality_ID`, `BG_MartDimension_Identity`, `BG_MartFact_ForeignKey_Identity`; `Integer`: `BG_ErrorCount` - Flags, `Integer`: `BG_IsDeleted` ### Platform differences The table compares the configuration with [Microsoft SQL Server Data Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-data-mart?hsLang=en) of the same release: | Item | Fabric Lakehouse | Microsoft SQL Server | | --- | --- | --- | | Timestamp Default Terms | `Timestamp` | `datetimeoffset` | | Hash Default Terms | `Binary` | `binary(20)` | | Text Default Terms | `String` | `nvarchar` | | Hash Algorithm default | `SHA-256` | `SHA1` | | Persist Validity default | on | off | | Deployment Options default | drop tables, create schemas | drop tables | | Enforced foreign keys | not available | available | | Index management | not available | available | Both platforms offer the LoadControl Option `Airflow`. The native load control is `Multi-Threading Notebook` on Fabric Lakehouse. ### Example A Mart Dimension `bk_multipart_not_nullable` with the business key terms `bdc_shop_id` and `bdc_customer_id` and SCD1 and SCD2 terms generates this table. The excerpt shows the example lakehouse `my_lakehouse` with the schema `mart` in place of the placeholders: ``` CREATE OR REPLACE TABLE `my_lakehouse`.`mart`. `dm_md_bk_multipart_not_nullable` ( `bg_sourcesystem` String ,`bg_loadtimestamp` Timestamp NOT NULL ,`bg_validfromtimestamp` Timestamp NOT NULL ,`bg_validtotimestamp` Timestamp ,`bk_multipart_not_nullable_sk` Long NOT NULL ,`bdc_shop_id` String NOT NULL ,`bdc_customer_id` String NOT NULL ,`first_name` String ,`last_name` String ,`date_of_birth` Date ,`location` String ,`bg_rowhashscd1` Binary NOT NULL ,`bg_rowhashscd2` Binary NOT NULL ) USING delta ``` The deployment then inserts the unknown-member row with `bk_multipart_not_nullable_sk` `-1`, the text `Unknown` and the date `1900-01-01`. The loader computes the surrogate key of each new row: ``` (unix_timestamp(current_timestamp()) * 1000000000) + (monotonically_increasing_id() % 1000000) AS `bk_multipart_not_nullable_sk` ``` ### Release differences Project Settings shows the Generator Version of your project. - Generator 2.0: Target Object Comment Type replaced the value `Target Platform` with `Tables` and `Tables and Views`, default `None`. Added the model object property [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) on Mart Fact, with the only value `None`. - Generator 2.2: added [Mart Out](https://knowledge.bigenius-x.com/mart-out?hsLang=en), the project properties Persist Validity, Create Result Views and the four Hash properties, and the model object property Increment Management Type on Mart Fact. Deployment Options added `Generate Create Schema If Not Exists Statements`, selected by default, and LoadControl Options added `Airflow`. - Generator 2.3: added the model object property [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en) on Mart Dimension. - Generator 1.10: the project property [Delta Detection](https://knowledge.bigenius-x.com/delta-detection-model-object?hsLang=en). Since Generator 2.0, Delta Detection is a property of the Mart Dimension. ### Related articles - Previous: - Fabric Lakehouse: [Target environment](https://knowledge.bigenius-x.com/fabric-lakehouse-target-environment?hsLang=en) - Azure Synapse: [Target environment](https://knowledge.bigenius-x.com/azure-synapse-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 Lakehouse: [Artifacts](https://knowledge.bigenius-x.com/fabric-lakehouse-artifacts?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-native-load-control?hsLang=en), [Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-apache-airflow-load-control?hsLang=en) - Azure Synapse: [Deployment](https://knowledge.bigenius-x.com/azure-synapse-deployment?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/azure-synapse-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), [Target Platform (Project)](https://knowledge.bigenius-x.com/target-platform-project?hsLang=en), [Deployment Options (Project)](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), [Notebook Deployment Objects Limit (Project)](https://knowledge.bigenius-x.com/notebook-deployment-objects-limit-project?hsLang=en), [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en), [Optimization Method (Model Object)](https://knowledge.bigenius-x.com/optimization-method-model-object?hsLang=en), [BG\_MartDimension\_Identity](https://knowledge.bigenius-x.com/bg_martdimension_identity?hsLang=en), [BG\_MartFact\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/bg_martfact_foreignkey_identity?hsLang=en) - Fabric Lakehouse: [Placeholder values](https://knowledge.bigenius-x.com/fabric-lakehouse-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), [Source systems per generator configuration](https://knowledge.bigenius-x.com/source-systems-per-generator-configuration?hsLang=en), [Use Linked Projects](https://knowledge.bigenius-x.com/use-linked-projects?hsLang=en), [Microsoft SQL Server Data Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-data-mart?hsLang=en) - Fabric Lakehouse: [Data Vault](https://knowledge.bigenius-x.com/fabric-lakehouse-data-vault?hsLang=en), [Data Vault and Mart](https://knowledge.bigenius-x.com/fabric-lakehouse-data-vault-and-mart?hsLang=en), [Data Store](https://knowledge.bigenius-x.com/fabric-lakehouse-data-store?hsLang=en), [Dimensional and Mart](https://knowledge.bigenius-x.com/fabric-lakehouse-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) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Databricks dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks-dbt) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Snowflake dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake-dbt) - [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 Azure DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azure-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) All rights reserved © 2025, biGENIUS AG