---
title: Databricks - DataVault and Mart
description: Databricks - DataVault and Mart generates a Stage, Raw Vault, Business Vault and Mart for Databricks as notebooks with SQL statements on Delta tables.
---

[Skip to content](https://knowledge.bigenius-x.com/databricks-datavault-and-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. [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)

# Databricks - DataVault and Mart

**Applies to**  
Platform: Databricks  
Architecture: Data Vault · Data Mart

Databricks - DataVault and Mart generates a Stage, Raw Vault, Business Vault and Mart for Databricks as notebooks with SQL statements on Delta tables. Select the Generator Configuration `Databricks DataVault & Mart` when you add a project whose Data Vault and data marts run on Databricks.

For dbt, select `Databricks Dbt DataVault & Mart` instead, see [Databricks dbt - DataVault and Mart](https://knowledge.bigenius-x.com/databricks-dbt-datavault-and-mart?hsLang=en).

### Scope and output

- Platform: Databricks. Each layer is a schema of a Unity Catalog catalog or, with [Use Unity Catalog](https://knowledge.bigenius-x.com/unity-catalog-project?hsLang=en) off, a Hive metastore database.
- 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 `Jupyter` and `LoadControl`, and `deploy.ps1`, described in [Databricks - Artifacts](https://knowledge.bigenius-x.com/databricks-artifacts?hsLang=en).

### Prerequisites

- A Databricks workspace with a catalog for the project, or with the Hive metastore a storage location per layer. The deployment creates the schemas or databases.
- An all-purpose cluster and a user who can create tables and run jobs on it, and read the source tables.
- PowerShell 7 and the Databricks CLI for `deploy.ps1`.

The setup is described in [Databricks - Target environment with Unity Catalog](https://knowledge.bigenius-x.com/databricks-unity-target-environment?hsLang=en) and [Databricks - Target environment with the Hive metastore](https://knowledge.bigenius-x.com/databricks-target-environment?hsLang=en), the placeholders in [Databricks - Placeholder values](https://knowledge.bigenius-x.com/databricks-placeholder-values?hsLang=en).

### Sources and linked projects

Stage source views read each source table as `<catalog>.<schema>.<table>` with placeholders of the source system. [Discover a Databricks Unity Catalog](https://knowledge.bigenius-x.com/discover-a-databricks-unity-catalog?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 [Databricks - Stage Files](https://knowledge.bigenius-x.com/databricks-stage-files?hsLang=en) or [Databricks - Stage JDBC](https://knowledge.bigenius-x.com/databricks-stage-jdbc?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, with Unity Catalog only: Hubs and Links have their hash key, Mart Dimensions their identity column `<model object name>_sk`, as primary key and, with Use Unique Constraints, a UNIQUE constraint on the business key terms of all three. Databricks does not enforce them, see [Constraints on Databricks](https://docs.databricks.com/aws/en/tables/constraints). Databricks Runtime 17.3 LTS rejects UNIQUE constraints, see [Databricks - Deployment](https://knowledge.bigenius-x.com/databricks-deployment?hsLang=en#a-table-with-a-unique-constraint-is-not-created).
- Foreign keys: [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) offers `None` and `Create Disabled` (default), not `Create Enforced`. `Create Disabled` adds the constraint as `NOT ENFORCED`.
- Unknown member: Hubs, Links, Satellites and Link Satellites get a row with the hash key `X'00'`, Mart Dimensions one with the surrogate key `-1`. [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/databricks-deployment?hsLang=en#redeploy-and-keep-data) in [Databricks - Deployment](https://knowledge.bigenius-x.com/databricks-deployment?hsLang=en).
- Governance: [Apply Sensitivity Level Tags](https://knowledge.bigenius-x.com/apply-sensitivity-level-tags-project?hsLang=en) adds a tags notebook that the deployment does not run.

### 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`
- [Use Unity Catalog](https://knowledge.bigenius-x.com/unity-catalog-project?hsLang=en): on
- [Use Unique Constraints](https://knowledge.bigenius-x.com/use-unique-constraints-project?hsLang=en): on
- [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en): `Generate Drop Table Statements` and `Generate Create Schema If Not Exists Statements`; also `Generate Alter View Body Statements`
- [Notebook Deployment Objects Limit](https://knowledge.bigenius-x.com/notebook-deployment-objects-limit-project?hsLang=en): `100`
- [Apply Sensitivity Level Tags](https://knowledge.bigenius-x.com/apply-sensitivity-level-tags-project?hsLang=en): off
- [Sensitivity Level Tag Name](https://knowledge.bigenius-x.com/sensitivity-level-tag-name-project?hsLang=en): `sensitivity_level`
- [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`

Older projects can still show the legacy property [Behaviour for Nulled Business Keys in Links](https://knowledge.bigenius-x.com/behaviour-for-nulled-business-keys-in-links?hsLang=en); the data quality rules replace it, see [Understand Data Quality rules overview](https://knowledge.bigenius-x.com/understand-data-quality-rules-overview?hsLang=en).

### 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?hsLang=en) of the same release:

| Item | Databricks | 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 Databricks.

### 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 catalog `dwh` with its layer schemas:

```
CREATE OR REPLACE VIEW
    `dwh`.`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 `dwh`.`businessvault`.`bdv_current_bdc_customer` AS `s1`
```

### Release differences

Project Settings shows the Generator Version of your project.

- Generator 2.0: Use Unity Catalog is on by default, off up to Generator 1.10. Target Object Comment Type replaced `Target Platform` with `Tables` and `Tables and Views`, default `None`. Deployment Options added `Generate Alter View Body Statements`. Added Business Driving Key Link.
- Generator 2.2: added Vault Out, Mart Out, the project properties Persist Validity, Create Result Views, the four Hash properties and the two Sensitivity Level properties, the model object property Increment Management Type, and the relationship property Use Embryo Loader. Deployment Options added `Generate Create Schema If Not Exists Statements`, selected by default.
- 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 the project property [Use Unique Constraints](https://knowledge.bigenius-x.com/use-unique-constraints-project?hsLang=en); Non-Historized Satellite and Non-Historized Business Satellite; 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: 
    - Databricks: [Target environment with Unity Catalog](https://knowledge.bigenius-x.com/databricks-unity-target-environment?hsLang=en), [Target environment with the Hive metastore](https://knowledge.bigenius-x.com/databricks-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) 
    - Databricks: [Artifacts](https://knowledge.bigenius-x.com/databricks-artifacts?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/databricks-deployment?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/databricks-load-data-native-load-control?hsLang=en), [Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/databricks-load-data-apache-airflow-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), [Excluded from Delta Detection (Model Object)](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?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), [Use Unity Catalog (Project)](https://knowledge.bigenius-x.com/unity-catalog-project?hsLang=en), [Use Unique Constraints (Project)](https://knowledge.bigenius-x.com/use-unique-constraints-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) 
    - Databricks: [Placeholder values](https://knowledge.bigenius-x.com/databricks-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 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?hsLang=en) 
    - Databricks: [DataVault](https://knowledge.bigenius-x.com/databricks-datavault?hsLang=en), [Datamart](https://knowledge.bigenius-x.com/databricks-datamart?hsLang=en), [Dimensional and Mart](https://knowledge.bigenius-x.com/databricks-dimensional-and-mart?hsLang=en)
    - Databricks dbt: [DataVault and Mart](https://knowledge.bigenius-x.com/databricks-dbt-datavault-and-mart?hsLang=en), [Target environment](https://knowledge.bigenius-x.com/databricks-dbt-target-environment?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