--- title: Databricks dbt Data Vault and Mart description: Databricks dbt Data Vault and Mart generates a Stage, Raw Vault, Business Vault and Mart for Databricks as one dbt project. --- [Skip to content](https://knowledge.bigenius-x.com/databricks-dbt-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. [Databricks dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks-dbt) # Databricks dbt Data Vault and Mart **Applies to** Platform: Databricks dbt Architecture: Data Vault · Data Mart Databricks dbt Data Vault and Mart generates a Stage, Raw Vault, Business Vault and Mart for Databricks as one dbt project. Select it in Project Settings, where Generator Configuration shows `Databricks Dbt DataVault & Mart`, when the Mart reads the Data Vault of the same project instead of a linked project. This article lists what the configuration supports and where it differs from [Databricks Data Vault and Mart](https://knowledge.bigenius-x.com/databricks-data-vault-and-mart?hsLang=en). The Raw Vault and Business Vault objects have the properties, Implementation Types and dbt models described in [Databricks dbt Data Vault](https://knowledge.bigenius-x.com/databricks-dbt-data-vault?hsLang=en), the Mart objects those described in [Databricks dbt Data Mart](https://knowledge.bigenius-x.com/databricks-dbt-data-mart?hsLang=en). This article covers what changes when both are in one project. The configuration offers no load control, no deployment scripts and no data quality checks. ### Scope and output - Platform: Databricks with Unity Catalog. The configuration is available since Generator 2.2; Generator 2.1 contained a preview. - Layers: Source, Stage, Raw Vault, Business Vault and Mart. See [Understand the Layering concept](https://knowledge.bigenius-x.com/understand-the-layering-concept?hsLang=en). - Output: one dbt project with the model folders `models/stage`, `models/rawvault`, `models/businessvault` and `models/mart`, described in [dbt - Artifacts](https://knowledge.bigenius-x.com/dbt-artifacts?hsLang=en). dbt creates and loads the tables, see [dbt - Deployment](https://knowledge.bigenius-x.com/dbt-deployment?hsLang=en). ### Prerequisites - A Databricks workspace with Unity Catalog, dbt Core with the adapter dbt-databricks, and a connection profile, as described in [Databricks dbt - Target environment](https://knowledge.bigenius-x.com/databricks-dbt-target-environment?hsLang=en). dbt 2 is not supported with Databricks dbt. - The values in `dbt_project.yml`, listed in [dbt - Placeholder values](https://knowledge.bigenius-x.com/dbt-placeholder-values?hsLang=en). ### How the Mart reads the vault dbt writes each layer into the schema `_` in the catalog of the connection profile. `` is the schema of the profile. `` is the `+schema` value of the layer in `dbt_project.yml`. The Mart models read the vault models with `ref()`, not as dbt sources. Therefore one `dbt run` builds Stage, Raw Vault, Business Vault and Mart in dependency order, and each Mart model runs after the vault models it reads. The project needs no linked project and no variables for the vault, unlike [Databricks dbt Data Mart](https://knowledge.bigenius-x.com/databricks-dbt-data-mart?hsLang=en). With [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) off (default), the Mart models read the vault tables and views, for example `rdv_lsat_`. With it on, they read the result view of a vault object that has one, for example `rdv_lsat__result`. ### Sources of the Mart objects - Source systems have the type `Spark`, see [Discover a Databricks Unity Catalog](https://knowledge.bigenius-x.com/discover-a-databricks-unity-catalog?hsLang=en). - The Mart objects read the Raw Vault and Business Vault objects of the project, [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en) and other Mart objects. They cannot read Source or Stage objects. The article of each Mart object lists the model object types it accepts. - Vault Out is a source of Mart Composite, Mart Dimension, Mart Fact and Mart Hierarchy Flatten since Generator 2.2. - The wizards Create Mart Composite, Create Mart Dimension and Create Mart Fact are available on Vault Out and on the vault objects. Create Mart Out is available on the Mart objects. Mart Hierarchy Flatten has no wizard. ### Supported model objects Source, Stage, Raw Vault and Business Vault: the model object types listed in [Databricks dbt Data Vault](https://knowledge.bigenius-x.com/databricks-dbt-data-vault?hsLang=en#supported-model-objects), including Vault Out. 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) ### Capabilities and limitations - Loading: dbt runs the models of all layers in the order of their references. Vault objects and Mart Facts with more than one dataflow get one loader model per dataflow. - Incremental reads: a vault model, or a Mart Fact with the Fact Load Strategy `Insert` that reads a vault object, reads only new rows when `BG_IncrementalFilter` is mapped to the source's `BG_LoadTimestamp`. See [Configure an incremental load](https://knowledge.bigenius-x.com/configure-an-incremental-load?hsLang=en). Such a Mart Fact compares the `BG_LoadTimestamp` of the vault object with the latest `BG_LoadTimestamp` in its own table. The Mart Fact reads every new vault row. For the effect of a full refresh on Mart Facts, see [Full refresh](https://knowledge.bigenius-x.com/dbt-deployment?hsLang=en#full-refresh) in dbt - Deployment. - Run the vault and the Mart Fact in the same `dbt run` or one after the other: when a separate vault run starts before a Mart Fact run and ends after it, the Mart Fact can skip rows of that vault run. - Without an incremental read filter, a Mart Fact with the Fact Load Strategy `Insert` inserts all source rows again on every run. - Historization: Mart Dimensions with SCD2 terms allow one dataflow. - Validity: historized satellites and Mart Dimensions with SCD2 terms need [Persist Validity](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en) or Create Result Views. With both off, validation reports the error `Model object uses historization, but result views are disabled and validity is not persisted.` for each historized satellite, such as a Satellite or Link Satellite. The error blocks generation in the client, see [Historization without result views or persisted validity](https://knowledge.bigenius-x.com/historization-without-result-views-or-persisted-validity-business-rule?hsLang=en). - Keys: the model YAML files declare primary keys, unique constraints on business keys and, with [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) `Create Disabled` (default), foreign keys. In the Mart only Mart Facts get foreign keys, to the Mart Dimensions they reference. No foreign key points from a Mart object to a vault object. Foreign Key Mode offers `None` and `Create Disabled`. - Hashes: [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en) offers only `SHA-256`. Hash keys and row hashes have the data type `Binary`. The properties that [Databricks dbt Data Vault](https://knowledge.bigenius-x.com/databricks-dbt-data-vault?hsLang=en) and [Databricks dbt Data Mart](https://knowledge.bigenius-x.com/databricks-dbt-data-mart?hsLang=en) list as not available are missing here too, among them the load control properties, [Load Caching](https://knowledge.bigenius-x.com/load-caching-model-object?hsLang=en) and Use Embryo Loader (see [Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en)). ### Project properties Project Settings shows the project properties of [Databricks dbt Data Vault](https://knowledge.bigenius-x.com/databricks-dbt-data-vault?hsLang=en#project-properties) with the same defaults, among them Persist Validity on, Create Result Views off and [Use Unique Constraints](https://knowledge.bigenius-x.com/use-unique-constraints-project?hsLang=en) on. ### Platform differences Compared with Databricks Data Vault and Mart of the same release: - Output: a dbt project with SQL models instead of PySpark notebooks and deployment scripts. There is no load control and no Apache Airflow option. - Create Result Views: off by default; on by default in Databricks Data Vault and Mart. - Target Object Comment Type: no value `Tables`. - Unity Catalog: always used; Databricks Data Vault and Mart has the property Use Unity Catalog. ### Example A Mart Dimension `common_salestransaction` reads the Link Satellite `SALESTRANSACTION` of the Raw Vault. Its model `dm_md_common_salestransaction_source` reads the vault model with `ref()`. Excerpt without the other columns: ``` SELECT CAST(NULL AS String) AS `bg_sourcesystem` ,`s1`.`link_hk` AS `link_hk` FROM {{ ref('rdv_lsat_salestransaction') }} AS `s1` ``` List the models that a run of this dimension includes: ``` dbt ls --select +dm_md_common_salestransaction --output name ``` dbt lists 26 models and five source tables. The models are the Mart Dimension, the Link Satellite, its Link, five Hubs and five Stage objects, each with its `_source` model. `dbt run` with the same selection builds the Stage models first, then the Raw Vault models, then the Mart Dimension. With Create Result Views on, the excerpt reads `ref('rdv_lsat_salestransaction_result')`. ### Release differences Project Settings shows the Generator Version of your project. - Generator 2.2: first release after the preview in Generator 2.1. Compared with the preview: Vault Out, also as a source of the Mart objects; Create Result Views, default off; the Foreign Key Mode value `Create Disabled` with primary key and foreign key constraints; the incremental read filter on `BG_LoadTimestamp`; loaders for more than one dataflow; Reference Tables without an unknown-member row. - Generator 2.3: the catalog and schema of each source system are variables in `dbt_project.yml`; the model object property [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en); a fix of the Mart Out deduplication. See [Generators Release - 2.3.0](https://knowledge.bigenius-x.com/generators-release-2.3.0?hsLang=en). - Generator 2.4: Non-Historized Satellite and Non-Historized Business Satellite; [Excluded from Delta Detection](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en); Use Unique Constraints; the materializations apply the constraints; table columns use the modeled data types. See [Generators Release - 2.4.0](https://knowledge.bigenius-x.com/generators-release-2.4.0?hsLang=en). - Generator 2.4.1: Driving Key Links and Business Driving Key Links with more than one dataflow no longer report the validation warning ID-10065. The generated models stay the same. See [Generators Release - 2.4.1](https://knowledge.bigenius-x.com/generators-release-2.4.1?hsLang=en). ### Related articles - Previous: [Databricks dbt - Target environment](https://knowledge.bigenius-x.com/databricks-dbt-target-environment?hsLang=en) - Next: [Generate artifacts](https://knowledge.bigenius-x.com/generate-artifacts?hsLang=en), [dbt - Placeholder values](https://knowledge.bigenius-x.com/dbt-placeholder-values?hsLang=en), [dbt - Deployment](https://knowledge.bigenius-x.com/dbt-deployment?hsLang=en) - Reference: [dbt - Artifacts](https://knowledge.bigenius-x.com/dbt-artifacts?hsLang=en), [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en), [Foreign Key Mode (Model Object)](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en), [Implementation Type (Model Object)](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en), [Create Result Views (Project)](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en), [Persist Validity (Project)](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en), [Use Unique Constraints (Project)](https://knowledge.bigenius-x.com/use-unique-constraints-project?hsLang=en) - See also: [Available Generator Configurations](https://knowledge.bigenius-x.com/available-generator-configurations?hsLang=en), [Source systems per generator configuration](https://knowledge.bigenius-x.com/source-systems-per-generator-configuration?hsLang=en), [Databricks Data Vault and Mart](https://knowledge.bigenius-x.com/databricks-data-vault-and-mart?hsLang=en), [Databricks dbt Data Vault](https://knowledge.bigenius-x.com/databricks-dbt-data-vault?hsLang=en), [Databricks dbt Data Mart](https://knowledge.bigenius-x.com/databricks-dbt-data-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