--- title: History View description: A History View shows every version of the satellites of a Hub or Link with its validity, as a view in the Raw Vault layer. --- [Skip to content](https://knowledge.bigenius-x.com/create-a-history-view#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) # History View **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Vault A History View shows every version of the satellites of a Hub or Link with its validity, as a view in the Raw Vault layer. Use it as a query layer or as the source of Business Vault objects and marts that need the history of a business key. The view has no table and no loader, so it always reflects the last load. ### Sources and relationships A History View has exactly one dataflow with one dataflow set and no relationships. The dataflow set contains: - Exactly one [Hub](https://knowledge.bigenius-x.com/create-a-hub?hsLang=en), [Link](https://knowledge.bigenius-x.com/create-a-link?hsLang=en), [Hierarchical Link](https://knowledge.bigenius-x.com/create-a-hierachical-link?hsLang=en) or [Driving Key Link](https://knowledge.bigenius-x.com/create-a-driving-key-link?hsLang=en). - Either one [PIT](https://knowledge.bigenius-x.com/create-a-pit?hsLang=en) of that Hub or Link and the satellites of the PIT whose terms you need, or no PIT and exactly one satellite. The satellites can be [Satellites](https://knowledge.bigenius-x.com/create-a-satellite?hsLang=en), [Link Satellites](https://knowledge.bigenius-x.com/create-a-link-satellite?hsLang=en), [Effectivity Satellites](https://knowledge.bigenius-x.com/create-an-effectivity-satellite?hsLang=en) and [Effectivity Link Satellites](https://knowledge.bigenius-x.com/create-an-effectivity-link-satellite?hsLang=en). Business Vault types, BusinessVault Composite and [Vault Out](https://knowledge.bigenius-x.com/create-a-vault-out?hsLang=en) can read a History View. ### Create the model object There is no wizard. [Create a model object](https://knowledge.bigenius-x.com/create-a-model-object?hsLang=en) of type History View 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) you want to show: usually the hash key and business keys of the Hub or Link and the descriptive terms of the satellites. You do not write join expressions; the generator builds the joins. A filter expression of the dataflow set is added to the view. ### How the view builds the history - With a PIT: the view returns one row per row of the PIT result view, with its `BG_ValidFromTimestamp` and `BG_ValidToTimestamp`. It joins the Hub or Link on the PIT key and each satellite table on the satellite key and `BG_ValidFromTimestamp` that the PIT row references. A satellite without a version at that point contributes the values of its unknown-member row. - Without a PIT: the view returns one row per version of the satellite result view, with the validity of that version, joined with the Hub or Link result view on the key. ### Properties - [Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en): `Virtual` only. ### Default Terms - [`BG_ValidFromTimestamp`](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en): start of the validity of the row, from the PIT or the satellite. - [`BG_ValidToTimestamp`](https://knowledge.bigenius-x.com/bg_validtotimestamp?hsLang=en): end of the validity of the row, from the PIT or the satellite. ### Generated objects On Microsoft SQL Server, a History View generates one object, the view `RDV_History_`, where `` stands for the name of the model object. Its target object role is Result. - There is no source view, loader or table, and no unknown-member row. - The view exists also when the project property [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) is false. - It reads the PIT result view, the Hub or Link result view and, with a PIT, the satellite tables or, without a PIT, the satellite result view. A load does not run the view. It shows the data after these objects are loaded: ``` Hub or Link, satellites -> PIT (optional) -> RDV_History_ ``` ### Example The History View `based_on_customer_hub_with_pit_rhv` on Microsoft SQL Server reads the PIT `customer_based_on_hub`, the Hub `load_customer_hub` and the two Satellites of the PIT. `load_customer_sat` holds the customer name, and `load_caching_hashing` holds the address. The view maps `CUSTOMER_ID`, `CUSTOMER`, `ZIP_CODE` and other terms. Persist Validity is false. The loads deliver these customers: - Load 1 on 2026-10-28 08:00: customer 1 Contoso Ltd with ZIP code 8001 and customer 2 Fabrikam AG with 10117. - Load 2 on 2026-10-29 08:00: customer 1 is renamed to Contoso Group, and customer 3 Northwind with 1010 arrives. - Load 3 on 2026-10-30 08:00: customer 1 moves to ZIP code 8005. - Load 4 on 2026-10-31 08:00: no change. ### Check the result Query the view, here in the schema `p2`: ``` SELECT CUSTOMER_ID, CUSTOMER, ZIP_CODE, BG_ValidFromTimestamp, BG_ValidToTimestamp FROM p2.RDV_History_based_on_customer_hub_with_pit_rhv ORDER BY CUSTOMER_ID, BG_ValidFromTimestamp; ``` This is the result after load 4, with the column names and timestamps shortened: ``` ID CUSTOMER ZIP_CODE ValidFrom ValidTo 1 Contoso Ltd 8001 2026-10-28 08:00 2026-10-29 08:00 1 Contoso Group 8001 2026-10-29 08:00 2026-10-30 08:00 1 Contoso Group 8005 2026-10-30 08:00 9999-12-31 00:00 2 Fabrikam AG 10117 2026-10-28 08:00 9999-12-31 00:00 3 Northwind 1010 2026-10-29 08:00 9999-12-31 00:00 ``` - Customer 1 has three rows: one per point in time of the PIT. Each row combines the name and the ZIP code valid at that time. - The last row of each customer is valid until the End of Universe. ### Platform differences - Snowflake: names are in capitals. The dataflow property [Warehouse Placeholder Variable Name](https://knowledge.bigenius-x.com/warehouse-placeholder-variable-name-dataflow?hsLang=en) applies. - Databricks and Fabric Lakehouse: the view name is in lowercase. - Databricks dbt and Snowflake dbt: the History View becomes the dbt model `rdv_history_`. - Fabric Warehouse: the same view as on Microsoft SQL Server, deployed by notebooks. - Oracle: names are in capitals. ### Limitations - A History View holds exactly one Hub, Link, Hierarchical Link or Driving Key Link, and at most one PIT. Without a PIT it holds exactly one satellite. Validation reports an error otherwise. - When the view maps the `DrivingKeyLink_HK` of a Driving Key Link, it cannot read a PIT. - A History View does not read Multi-Active, Record Tracking or Non-Historized satellites. ### Related articles - Previous: [PIT](https://knowledge.bigenius-x.com/create-a-pit?hsLang=en), [Satellite](https://knowledge.bigenius-x.com/create-a-satellite?hsLang=en) - Reference: [BG\_ValidFromTimestamp](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en), [BG\_ValidToTimestamp](https://knowledge.bigenius-x.com/bg_validtotimestamp?hsLang=en), [Create Result Views (Project)](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en), [End of Universe (Project)](https://knowledge.bigenius-x.com/end-of-universe-project?hsLang=en) - See also: [Current View](https://knowledge.bigenius-x.com/create-a-current-view?hsLang=en), [Business History View](https://knowledge.bigenius-x.com/create-a-business-history-view?hsLang=en), [Model a Data Vault Solution](https://knowledge.bigenius-x.com/model-a-data-vault-solution?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