--- title: RawVault Composite description: A RawVault Composite prepares source data with joins, filters and expressions in the Raw Vault layer, as a view or as a table reloaded per load. --- [Skip to content](https://knowledge.bigenius-x.com/rawvault-composite#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. [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) # RawVault Composite **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Vault A RawVault Composite prepares source data with joins, filters and expressions in the Raw Vault layer, as a view or as a table reloaded per load. Use it when Hubs, Links or satellites need data that no single Stage delivers in the right shape, for example one Stage filtered or two Stages joined. The Raw Vault objects then read it like a Stage. Earlier versions of this article spelled the type "Raw Vault Composite". ### Sources and relationships A RawVault Composite reads [Stages](https://knowledge.bigenius-x.com/stage?hsLang=en), [Store Entities](https://knowledge.bigenius-x.com/store-entity?hsLang=en) of a linked Data Store project and other RawVault Composites. It has exactly one dataflow, with one or more dataflow sets, and no relationships. Its terms are the columns it delivers, at least one besides the Default Terms. Hubs, Links, all Raw Vault satellite types, Reference Tables, other RawVault Composites and the [Business Driving Key Link](https://knowledge.bigenius-x.com/business-driving-key-link?hsLang=en) can read it. ### Create the model object - With the wizard: open the menu of a Stage, Store Entity or RawVault Composite, choose **Automate** and then **Create RawVault Composite**. Its steps are [Create Model Object](https://knowledge.bigenius-x.com/wizard-step-create-model-object?hsLang=en), [Create Dataflow](https://knowledge.bigenius-x.com/wizard-step-create-dataflow?hsLang=en), [Map Selected Terms](https://knowledge.bigenius-x.com/wizard-step-map-selected-terms?hsLang=en) and [Add to View](https://knowledge.bigenius-x.com/wizard-step-add-to-view?hsLang=en). See [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?hsLang=en). - Manually: [create a model object](https://knowledge.bigenius-x.com/create-a-model-object?hsLang=en) of type RawVault Composite in the Raw Vault layer, [create a dataflow set](https://knowledge.bigenius-x.com/create-a-data-flow-set?hsLang=en), [add the source model objects](https://knowledge.bigenius-x.com/add-a-model-object-into-a-data-flow-set?hsLang=en) and [map the terms](https://knowledge.bigenius-x.com/map-a-source-term-with-a-target-term?hsLang=en). Add join, filter and term expressions in the dataflow set. ### Implementation types - `Virtual` (default): the composite is a view over its sources. A query always shows the current content of the sources, and there is no loader. - `Cached`: the composite has a table. Its loader empties the table and inserts all rows of the source view, with the load timestamp as `BG_LoadTimestamp`. A query shows the content of the last load. ### Properties - [Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en): `Virtual` (default) or `Cached`. - [Deduplication Method](https://knowledge.bigenius-x.com/deduplication-method-dataflow?hsLang=en) and [Sort Order within Partition](https://knowledge.bigenius-x.com/sort-order-within-partition-dataflow?hsLang=en), per dataflow. `Partition` uses the business keys of the composite; without business keys, validation reports a warning. The project property [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) also applies. ### Default Terms - [`BG_LoadTimestamp`](https://knowledge.bigenius-x.com/bg_loadtimestamp?hsLang=en): with `Cached`, the load that filled the table. With `Virtual`, empty unless you map it. - [`BG_SourceSystem`](https://knowledge.bigenius-x.com/bg_sourcesystem?hsLang=en): the source system, empty unless you map it. ### Generated objects These are the names on Microsoft SQL Server. `` stands for the name of the model object: | Role | Generated name | Purpose | | --- | --- | --- | | Source | `RDV_RC__Source` | Joins, filters and maps | | Deduplication | `RDV_RC__Deduplication` | Removes duplicate rows | | Loader | `RDV_RC__Loader` | Reloads the table | | Storage | `RDV_RC_` | Composite table | | Result | `RDV_RC__Result` | Query view | - The loader is a stored procedure and the composite table is a table; the other objects are views. - The loader and the table exist only with Implementation Type `Cached`. - The deduplication view exists only with a Deduplication Method other than `None`. - The result view exists only with Create Result Views. - The table has no primary key and no unknown-member row. The chain depends on the implementation type: ``` Virtual: sources -> _Source -> _Result Cached: sources -> _Source -> _Loader -> RDV_RC_ RDV_RC_ -> _Result ``` With `Virtual`, the result view reads the source view. With `Cached`, it reads the table. `_Deduplication` sits after `_Source`. ### Example Two RawVault Composites on Microsoft SQL Server read the Stage `CUSTOMER` and map `CUSTOMER_ID` and `CUSTOMER`: `load_virtual_rvc` with Implementation Type `Virtual` and `load_cached_rvc` with `Cached`. The Stage receives these customers: - Load 3 on 2026-10-30 08:00: customers 1 Contoso Group and 3 Northwind. The loader of `load_cached_rvc` runs. - Next, the Stage receives the data of load 4: customers 1, 2 Fabrikam AG and 3. The loader of `load_cached_rvc` has not run yet. ### Check the result Query both result views, here in the schema `p2`: ``` SELECT 'virtual' AS IMPL, CUSTOMER_ID, CUSTOMER, BG_LoadTimestamp FROM p2.RDV_RC_load_virtual_rvc_Result UNION ALL SELECT 'cached', CUSTOMER_ID, CUSTOMER, BG_LoadTimestamp FROM p2.RDV_RC_load_cached_rvc_Result ORDER BY IMPL DESC, CUSTOMER_ID; ``` This is the result before the loader of load 4 runs, with the timestamps shortened: ``` IMPL CUSTOMER_ID CUSTOMER BG_LoadTimestamp virtual 1 Contoso Group NULL virtual 2 Fabrikam AG NULL virtual 3 Northwind NULL cached 1 Contoso Group 2026-10-30 08:00 cached 3 Northwind 2026-10-30 08:00 ``` - The virtual composite already shows customer 2 from the new Stage data. Its `BG_LoadTimestamp` is empty because the dataflow does not map it. - The cached composite shows the content of load 3. After its loader runs for load 4, it holds customers 1, 2 and 3. ### Platform differences - Snowflake: names are in capitals, and the loader of a cached composite is a stored procedure. A load control task calls it. The dataflow properties [Use Stream](https://knowledge.bigenius-x.com/use-stream-model-object?hsLang=en) and [Warehouse Placeholder Variable Name](https://knowledge.bigenius-x.com/warehouse-placeholder-variable-name-dataflow?hsLang=en) apply. - Databricks and Fabric Lakehouse: table and view names are in lowercase, and the loader of a cached composite is the notebook `RDV_RC__Loader`. The properties [File Format](https://knowledge.bigenius-x.com/file-format-model-object?hsLang=en), [Optimization Method](https://knowledge.bigenius-x.com/optimization-method-model-object?hsLang=en) and [Optimization Method Columns](https://knowledge.bigenius-x.com/optimization-method-columns-model-object?hsLang=en) apply. - Databricks dbt and Snowflake dbt: the RawVault Composite becomes the dbt model `rdv_rc__source`, and with `Cached` also `rdv_rc_`. The model `rdv_rc__result` exists only when Create Result Views is true; the default on dbt is false. - Fabric Warehouse: the same objects as on Microsoft SQL Server, deployed by notebooks. - Oracle: names are in capitals, and the loader of a cached composite is a PL/SQL package. [Partition Clause](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object?hsLang=en) adds its text to the `CREATE TABLE` statement. Table Compression, the tablespaces and the statistics properties also apply. ### Limitations - A RawVault Composite has exactly one dataflow and no relationships. Validation reports an error otherwise. - Implementation Type `Permanent` is not available. An index on a virtual composite raises a validation warning. - A dataflow that reads the composite itself, directly or through other composites, raises a validation error. ### Related articles - Previous: [Stage](https://knowledge.bigenius-x.com/stage?hsLang=en) - Next: [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) - Reference: [Implementation Type (Model Object)](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en), [Deduplication Method (Dataflow)](https://knowledge.bigenius-x.com/deduplication-method-dataflow?hsLang=en), [Create Result Views (Project)](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) - See also: [BusinessVault Composite](https://knowledge.bigenius-x.com/businessvault-composite?hsLang=en), [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?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