--- title: Snowflake Data Vault and Mart description: Snowflake Data Vault and Mart generates a Stage, Raw Vault, Business Vault and Mart for Snowflake as SnowSQL scripts with stored procedure loaders. --- [Skip to content](https://knowledge.bigenius-x.com/snowflake-data-vault-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. [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) # Snowflake Data Vault and Mart **Applies to** Platform: Snowflake Architecture: Data Vault · Data Mart Snowflake Data Vault and Mart generates a Stage, Raw Vault, Business Vault and Mart for Snowflake as SnowSQL scripts with stored procedure loaders. Select the Generator Configuration `Snowflake DataVault & Mart` when you add a project whose Data Vault and data marts run on Snowflake. ### Scope and output - Platform: Snowflake. - Layers: Source, Stage, Raw Vault, Business Vault and Mart. Dataflow Modeling shows Stage in the Bronze column, both vault layers in the Silver column 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: the layer scripts `SQL\L010_Stage.sql` to `SQL\L040_Mart.sql`, the task scripts of the load control or an Airflow DAG in the folder `LoadControl`, and `deploy.ps1` with `deploy.sql`, described in [Snowflake - Artifacts](https://knowledge.bigenius-x.com/snowflake-artifacts?hsLang=en). ### Prerequisites - A Snowflake account with the databases of the layers and of the load control, and a warehouse. The deployment creates only the schemas. - A role that creates the objects, runs tasks and reads the source databases. - PowerShell 7 and SnowSQL with a named connection. The setup is described in [Snowflake - Target environment](https://knowledge.bigenius-x.com/snowflake-target-environment?hsLang=en), the placeholders in [Snowflake - Placeholder values](https://knowledge.bigenius-x.com/snowflake-placeholder-values?hsLang=en). ### Sources and linked projects Stage source views read each source table as `..`, with placeholders for the database and schema. [Discover a Snowflake database](https://knowledge.bigenius-x.com/discover-a-snowflake-database?hsLang=en) creates the source model objects, and [Source systems per generator configuration](https://knowledge.bigenius-x.com/source-systems-per-generator-configuration?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) as a source and [export this project as a linked project](https://knowledge.bigenius-x.com/export-a-project-to-be-used-as-linked-project?hsLang=en). ### Supported model objects #### Source and Stage - [Source](https://knowledge.bigenius-x.com/source?hsLang=en) - [Stage](https://knowledge.bigenius-x.com/stage?hsLang=en) #### Raw Vault - [Hub](https://knowledge.bigenius-x.com/hub?hsLang=en) - [Link](https://knowledge.bigenius-x.com/link?hsLang=en) - [Satellite](https://knowledge.bigenius-x.com/satellite?hsLang=en) - [Link Satellite](https://knowledge.bigenius-x.com/link-satellite?hsLang=en) - [Multi-Active Satellite](https://knowledge.bigenius-x.com/multi-active-satellite?hsLang=en) - [Same As Link](https://knowledge.bigenius-x.com/same-as-link?hsLang=en) - [Hierarchical Link](https://knowledge.bigenius-x.com/hierarchical-link?hsLang=en) - [Driving Key Link](https://knowledge.bigenius-x.com/driving-key-link?hsLang=en) - [Record Tracking Satellite](https://knowledge.bigenius-x.com/record-tracking-satellite?hsLang=en) - [Effectivity Satellite](https://knowledge.bigenius-x.com/effectivity-satellite?hsLang=en) - [Record Tracking Link Satellite](https://knowledge.bigenius-x.com/record-tracking-link-satellite?hsLang=en) - [Effectivity Link Satellite](https://knowledge.bigenius-x.com/effectivity-link-satellite?hsLang=en) - [Non-Historized Link Satellite](https://knowledge.bigenius-x.com/non-historized-link-satellite?hsLang=en) - [Non-Historized Satellite](https://knowledge.bigenius-x.com/non-historized-satellite?hsLang=en), since Generator 2.4 - [PIT](https://knowledge.bigenius-x.com/pit?hsLang=en) - [Reference Table](https://knowledge.bigenius-x.com/reference-table?hsLang=en) - [RawVault Composite](https://knowledge.bigenius-x.com/rawvault-composite?hsLang=en) - [Current View](https://knowledge.bigenius-x.com/current-view?hsLang=en) - [History View](https://knowledge.bigenius-x.com/history-view?hsLang=en) #### Business Vault - [Business Hub](https://knowledge.bigenius-x.com/business-hub?hsLang=en) - [Business Link](https://knowledge.bigenius-x.com/business-link?hsLang=en) - [Business Satellite](https://knowledge.bigenius-x.com/business-satellite?hsLang=en) - [Business Link Satellite](https://knowledge.bigenius-x.com/business-link-satellite?hsLang=en) - [Same As Business Link](https://knowledge.bigenius-x.com/same-as-business-link?hsLang=en) - [Hierarchical Business Link](https://knowledge.bigenius-x.com/hierarchical-business-link?hsLang=en) - [Business Driving Key Link](https://knowledge.bigenius-x.com/business-driving-key-link?hsLang=en) - [Effectivity Business Satellite](https://knowledge.bigenius-x.com/effectivity-business-satellite?hsLang=en) - [Record Tracking Business Link Satellite](https://knowledge.bigenius-x.com/record-tracking-business-link-satellite?hsLang=en) - [Effectivity Business Link Satellite](https://knowledge.bigenius-x.com/effectivity-business-link-satellite?hsLang=en) - [Non-Historized Business Link Satellite](https://knowledge.bigenius-x.com/non-historized-business-link-satellite?hsLang=en) - [Non-Historized Business Satellite](https://knowledge.bigenius-x.com/non-historized-business-satellite?hsLang=en), since Generator 2.4 - [Business PIT](https://knowledge.bigenius-x.com/business-pit?hsLang=en) - [BusinessVault Composite](https://knowledge.bigenius-x.com/businessvault-composite?hsLang=en) - [Business Current View](https://knowledge.bigenius-x.com/business-current-view?hsLang=en) - [Business History View](https://knowledge.bigenius-x.com/business-history-view?hsLang=en) - [Hierarchy Flatten](https://knowledge.bigenius-x.com/hierarchy-flatten?hsLang=en) - [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en), since Generator 2.2 #### Mart - [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 - Names: generated names are upper case without quotes, for example `STG_ST_BDC_CUSTOMER`. - Loaders: stored procedures `
_LOADER` in Snowflake Scripting. Each loads in one transaction and logs its row counts with `SYSTEM$LOG_INFO`. - Tables: Stage tables are transient by default; vault tables are permanent. A Mart Dimension with Implementation Type `Cached` gets a transient table. - Keys: the primary key of a Hub or Link is its hash key, and of a Mart Dimension its surrogate key `_SK INTEGER IDENTITY ORDER`. Both get a unique constraint on the business key terms; a Mart Fact has no primary key. Snowflake does not enforce them, see [Overview of Constraints](https://docs.snowflake.com/en/sql-reference/constraints-overview). - 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` creates the foreign keys as `NOT ENFORCED` constraints; `None` creates no constraint. - Indexes: index management is not available. - Unknown member: Hubs, Links, Satellites and Link Satellites get a row with the hash key `X'00'`, and each Mart Dimension gets a row 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 `SHA2_BINARY(..., 256)` in `BINARY(32)` columns with the default Hash Algorithm. 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`; with it off, the result view computes it. - Change detection: with [Excluded from Delta Detection](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en), changes to the selected terms of a Satellite alone create no new version. - Loading order: [Use Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en) on a relationship inserts missing keys into the related Hub or Link 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 with empty ones and drops the load control schema. See [Snowflake - Deployment](https://knowledge.bigenius-x.com/snowflake-deployment?hsLang=en). - Loading: [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) offers Snowflake tasks and Apache Airflow. [Warehouse Placeholder Variable Name](https://knowledge.bigenius-x.com/warehouse-placeholder-variable-name-dataflow?hsLang=en) moves the tasks of a dataflow to another warehouse. - Governance: [Apply Sensitivity Level Tags](https://knowledge.bigenius-x.com/apply-sensitivity-level-tags-project?hsLang=en) adds a script that creates the tag `SENSITIVITY_LEVEL`. ### Project properties The configuration offers these project properties, with their defaults: - [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en): `SHA2-256`; also `HASH` 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): `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` - [Artifact Output Mode](https://knowledge.bigenius-x.com/artifact-output-mode-project?hsLang=en): `Layer Composites`; also `Deployment Objects` - [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en): `Generate Drop Table Statements` and `Generate Drop Load Control Schema` - [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 - [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en): `Depending Tasks`; also `Stage-Driven Tasks`, `Near-Realtime Tasks` and `Airflow` 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-project?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. `TIMESTAMP_TZ` has no precision, so Snowflake uses precision 9, and `VARCHAR` has no length: - Timestamps, `TIMESTAMP_TZ`: `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(32)`: `Hub_HK`, `Link_HK`, `DrivingKeyLink_HK`, `PIT_HK`, `DVLINK_ForeignKey_Identity`, `DVPIT_ForeignKey_Identity`, `BG_RowHash`, `BG_RowHashScd1`, `BG_RowHashScd2` - Text, `VARCHAR`: `BG_SourceSystem`, `BG_DataflowName`, `BG_DataflowSetName`, `BG_ErrorDescription`, `BG_IncrementLoadStatus` - Numbers, `INTEGER`: `BG_ID`, `BG_ErrorCount`, `BG_DataQuality_ID`, `BG_Sequence`, `BG_MartDimension_Identity`, `BG_MartFact_ForeignKey_Identity` - Flags, `BOOLEAN`: `BG_IsDeleted`, `BG_Appearance`, `BG_MAS_HubDifferenceFound` - `BG_IncrementalFilter`, `BG_LowerThreshold`, `BG_UpperThreshold`: the data type of the term that you map to `BG_IncrementalFilter` ### Platform differences The table compares the configuration with [Microsoft SQL Server Data Vault and Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-data-vault-and-mart?hsLang=en) of the same release: | Item | Snowflake | Microsoft SQL Server | | --- | --- | --- | | Timestamp Default Terms | `TIMESTAMP_TZ` | `datetimeoffset` | | Effectivity Default Terms | `TIMESTAMP_TZ` | `datetime2` | | Hash Default Terms | `BINARY(32)` | `binary(20)` | | Text Default Terms | `VARCHAR` | `nvarchar` | | Hash Algorithm default | `SHA2-256` | `SHA1` | | Persist Validity default | on | off | | Deployment Options default | both options | `Generate Drop Table Statements` | | Enforced foreign keys | not available | available | | Index management | not available | available | | [Deploy LoadControl](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en) | not available | available | On both platforms, LoadControl Options offers `Airflow` and a native load control: Snowflake tasks on Snowflake, `Native Load Control` on Microsoft SQL Server. ### Example A Mart Dimension `bk_multipart_not_nullable` reads the Business Current View `BDV_CURRENT_BDC_CUSTOMER` of the same project. The excerpt uses the example database `DWH` and the schemas `BV` and `MART` for the placeholders: ``` CREATE OR REPLACE VIEW DWH.MART.DM_MD_BK_MULTIPART_NOT_NULLABLE_SOURCE COPY GRANTS AS SELECT CAST(NULL AS VARCHAR) 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.BV.BDV_CURRENT_BDC_CUSTOMER AS S1 ; ``` The view `DM_MD_BK_MULTIPART_NOT_NULLABLE_HASHING` builds the row hash `BG_ROWHASHSCD1` of the four SCD1 terms `FIRST_NAME`, `LAST_NAME`, `DATE_OF_BIRTH` and `LOCATION` with `SHA2_BINARY(..., 256)`. ### Release differences Project Settings shows the Generator Version of your project. - Generator 2.2: Vault Out and Mart Out; the project properties Persist Validity, Create Result Views, Hash Casing, Hash Concatenation Separator, Hash Null Placeholder, Hash Trim, Apply Sensitivity Level Tags and Sensitivity Level Tag Name; the model object property Increment Management Type; the relationship property Use Embryo Loader. - Generator 2.3: the model object property [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en). - Generator 2.4: 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); Hash Algorithm defaults to `SHA2-256` instead of `HASH` and also offers `MD5`; the hash Default Terms are `BINARY(32)` instead of `NUMBER(19)`, see [Generators Release - 2.4.0](https://knowledge.bigenius-x.com/generators-release-2.4.0?hsLang=en). - 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: - Snowflake: [Target environment](https://knowledge.bigenius-x.com/snowflake-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) - Snowflake: [Artifacts](https://knowledge.bigenius-x.com/snowflake-artifacts?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/snowflake-deployment?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/snowflake-load-data-native-load-control?hsLang=en), [Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/snowflake-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-project?hsLang=en), [Hash Algorithm (Project)](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en), [Deployment Options (Project)](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en), [Use Stream (Model Object)](https://knowledge.bigenius-x.com/use-stream-model-object?hsLang=en), [Warehouse Placeholder Variable Name (Dataflow)](https://knowledge.bigenius-x.com/warehouse-placeholder-variable-name-dataflow?hsLang=en), [Ignore Downstream Dependencies (Dataflow Model Object)](https://knowledge.bigenius-x.com/ignore-downstream-dependencies-dataflow-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) - Snowflake: [Placeholder values](https://knowledge.bigenius-x.com/snowflake-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 Vault and Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-data-vault-and-mart?hsLang=en) - Snowflake: [Data Vault](https://knowledge.bigenius-x.com/snowflake-data-vault?hsLang=en), [Data Mart](https://knowledge.bigenius-x.com/snowflake-data-mart?hsLang=en), [Dimensional and Mart](https://knowledge.bigenius-x.com/snowflake-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