--- title: Fabric Lakehouse - DataVault and Mart description: Fabric Lakehouse - DataVault and Mart generates a Stage, Raw Vault, Business Vault and Mart for Microsoft Fabric, as notebooks on Delta tables. --- [Skip to content](https://knowledge.bigenius-x.com/fabric-lakehouse-datavault-and-mart-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 Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) # Fabric Lakehouse - DataVault and Mart **Applies to** Platform: Fabric Lakehouse Architecture: Data Vault · Data Mart Fabric Lakehouse - DataVault and Mart generates a Stage, Raw Vault, Business Vault and Mart for Microsoft Fabric, as notebooks on Delta tables. Select the Generator Configuration `Fabric Lakehouse DataVault & Mart` when you add a project whose Data Vault and 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: Source, Stage, Raw Vault, Business Vault and Mart. Dataflow Modeling shows Stage in Bronze, both vault layers in Silver and the Mart model objects in the Datamart column. 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-2.0?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-2.0?hsLang=en). ### Sources and linked projects The source system has the type `Spark`. Stage source views read each source table as `...` with placeholders of the source system. [Discover Parquet or Delta files on OneLake](https://knowledge.bigenius-x.com/discover-parquet-or-delta-files-on-onelake?hsLang=en) creates the source model objects; [Source Systems per Generator Configurations](https://knowledge.bigenius-x.com/source-systems-per-generator-configurations?hsLang=en) lists the discovery types. You can [import a linked project](https://knowledge.bigenius-x.com/import-a-project-to-be-used-as-a-linked-project?hsLang=en), for example a [Fabric Lakehouse - Stage Files](https://knowledge.bigenius-x.com/fabric-lakehouse-stage-files-2.0?hsLang=en) or [Fabric Lakehouse - Stage JDBC](https://knowledge.bigenius-x.com/fabric-lakehouse-stage-jdbc-2.0?hsLang=en) project, 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](https://knowledge.bigenius-x.com/business-driving-key-link?hsLang=en), since Generator 2.0 - [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) - [Hierarchy Flatten](https://knowledge.bigenius-x.com/create-a-hierachy-flatten?hsLang=en) - [Vault Out](https://knowledge.bigenius-x.com/create-a-vault-out?hsLang=en), since Generator 2.2 #### Mart - [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 Hierarchy Flatten](https://knowledge.bigenius-x.com/create-a-mart-hierachy-flatten?hsLang=en) - [Mart Out](https://knowledge.bigenius-x.com/create-a-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 hash key `X'00'` to Hubs, Links, Satellites and Link Satellites, and one with the surrogate key `-1` to Mart Dimensions. [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en) sets their values. - Hashing: hash keys and 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. - Change detection: changes to Satellite terms selected in [Excluded from Delta Detection](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en) alone create no new version. - Loading order: [Use Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en) on a relationship inserts missing Hub or Link keys before the Satellite loader runs. - 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-2.0?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 - [Behaviour for Nulled Business Keys in Links](https://knowledge.bigenius-x.com/behaviour-for-nulled-business-keys-in-links?hsLang=en): `Nulled Business Keys Point to Non-Existing Hub Key`; also `Nulled Business Keys Point to Hub Singleton` - [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`, `DVPIT_ForeignKey_LoadDate`, `BG_Effectivity_Begin`, `BG_Effectivity_End` - Hash keys and row hashes, `Binary`: `Hub_HK`, `Link_HK`, `DrivingKeyLink_HK`, `PIT_HK`, `DVLINK_ForeignKey_Identity`, `DVPIT_ForeignKey_Identity`, `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`, `BG_Sequence` - Flags, `Integer`: `BG_IsDeleted`, `BG_MAS_HubDifferenceFound`; `Boolean`: `BG_Appearance` ### Platform differences The table compares the configuration with [Microsoft SQL Server - DataVault and Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-datavault-and-mart-2.0?hsLang=en) of the same release: | Item | Fabric Lakehouse | Microsoft SQL Server | | --- | --- | --- | | Timestamp Default Terms | `Timestamp` | `datetimeoffset` | | Effectivity Default Terms | `Timestamp` | `datetime2` | | 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` reads the Business Current View `bdv_current_bdc_customer` of the same project. The excerpt shows the example lakehouse `my_lakehouse` with its layer schemas: ``` CREATE OR REPLACE VIEW `my_lakehouse`.`mart`.`dm_md_bk_multipart_not_nullable_source` AS SELECT CAST(NULL AS String) AS `bg_sourcesystem` ,`s1`.`bdc_shop_id` AS `bdc_shop_id` ,`s1`.`bdc_customer_id` AS `bdc_customer_id` ,`s1`.`first_name` AS `first_name` ,`s1`.`last_name` AS `last_name` ,`s1`.`date_of_birth` AS `date_of_birth` ,`s1`.`location` AS `location` FROM `my_lakehouse`.`businessvault`.`bdv_current_bdc_customer` AS `s1` ``` The loader `DM_MD_bk_multipart_not_nullable_Loader` merges new rows into the Mart Dimension and computes their surrogate key: ``` (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 Business Driving Key Link and the model object property [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en), with the only value `None`. - Generator 2.2: added [Vault Out](https://knowledge.bigenius-x.com/create-a-vault-out?hsLang=en), [Mart Out](https://knowledge.bigenius-x.com/create-a-mart-out?hsLang=en), the project properties Persist Validity, Create Result Views and the four Hash properties, the model object property Increment Management Type, and the relationship property [Use Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en). 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). - Generator 2.4: added Non-Historized Satellite and Non-Historized Business Satellite, and the model object property [Excluded from Delta Detection](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en). - Generator 1.10: the project property [Delta Detection](https://knowledge.bigenius-x.com/delta-detection-project?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-2.0?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment-2.0?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-native-load-control-2.0?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-2.0?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/azure-synapse-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), [Custom Singleton Values (Model Object)](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en), [Excluded from Delta Detection (Model Object)](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en), [Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en), [Delta Detection (Model Object)](https://knowledge.bigenius-x.com/delta-detection-model-object?hsLang=en), [Behaviour for Nulled Business Keys in Links (Project)](https://knowledge.bigenius-x.com/behaviour-for-nulled-business-keys-in-links?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-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), [Use Linked Projects](https://knowledge.bigenius-x.com/use-linked-projects?hsLang=en), [Microsoft SQL Server - DataVault and Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-datavault-and-mart-2.0?hsLang=en) - Fabric Lakehouse: [DataVault](https://knowledge.bigenius-x.com/fabric-lakehouse-datavault-2.0?hsLang=en), [Datamart](https://knowledge.bigenius-x.com/fabric-lakehouse-datamart-2.0?hsLang=en), [Dimensional and Mart](https://knowledge.bigenius-x.com/fabric-lakehouse-dimensional-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) - [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) All rights reserved © 2025, biGENIUS AG