--- title: BG_ValidToTimestamp description: BG_ValidToTimestamp is the Default Term that holds the end of the validity of a row version in a historized model object. --- [Skip to content](https://knowledge.bigenius-x.com/bg_validtotimestamp#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. [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) # BG\_ValidToTimestamp **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Store · Data Vault · Dimensional · Data Mart `BG_ValidToTimestamp` is the Default Term that holds the end of the validity of a row version in a historized model object. Use it to find the current version of a key or the version that was valid at a point in time. The term is carried by the same model objects as [BG\_ValidFromTimestamp](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en) and has the same data type. It cannot be mapped. ### Value - Closed version: the `BG_ValidFromTimestamp` of the next version of the same key. A version is valid from its `BG_ValidFromTimestamp` up to, but not including, its `BG_ValidToTimestamp`. - Current version: [End of Universe](https://knowledge.bigenius-x.com/end-of-universe-project?hsLang=en). The versions are ordered per key: - Store Entity, Entity, Mart Dimension: the business key. - Satellites: the hash key of the Hub or Link. - Link Satellite on a Driving Key Link or Business Driving Key Link: the hash key of the driving key, `DrivingKeyLink_HK`. If several links of one driving key have the same `BG_ValidFromTimestamp`, they are ordered by `Link_HK`. The one with the highest `Link_HK` stays current, and the others are closed at their own `BG_ValidFromTimestamp`. - Multi-Active Satellite: the hash key; the next set of rows closes the whole previous set. The driving-key and Multi-Active rules apply since Generator 2.4. ### Generated versus result-view behavior [Persist Validity](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en) decides where the value is calculated: - `false`: the table has no `BG_ValidToTimestamp` column. The result view calculates it. - `true`: the table has the column. The loader inserts each new version with End of Universe. In the same transaction, it sets the end of the previous current version of each loaded key. dbt models do this in the post-hook `bg_close_validity_merge`. The result view reads the stored value. On Microsoft SQL Server, the result view of a satellite calculates: ``` ISNULL(LEAD([BG_ValidFromTimestamp]) OVER (PARTITION BY [Hub_HK] ORDER BY [BG_ValidFromTimestamp]), N'99991231') ``` With [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) set to `false`, the value exists only when Persist Validity is `true`. Otherwise validation reports error ID-10064 for each historized Store Entity, Entity and satellite. Data Vault result views leave out the unknown-member row. In a table with a stored `BG_ValidToTimestamp`, that row has End of Universe. Both settings give the same values. Exception on Snowflake dbt and Databricks dbt: if one driving key gets several links in the same run, the post-hook `bg_close_validity_merge` fails. ### Example A Satellite on Microsoft SQL Server is loaded four times on 2026-10-27. Customer 1 changes its type at 11:00 and 13:00; the load at 12:00 brings no change. The result view shows customer 1 as: ``` CUSTOMER_TYPE BG_ValidFromTimestamp BG_ValidToTimestamp Business 2026-10-27 10:00 +00:00 2026-10-27 11:00 +00:00 Enterprise 2026-10-27 11:00 +00:00 2026-10-27 13:00 +00:00 Key Account 2026-10-27 13:00 +00:00 9999-12-31 00:00 +00:00 ``` With Persist Validity `true`, the table stores the same three values. ### Related articles - Reference: [BG\_ValidFromTimestamp](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en), [Persist Validity (Project)](https://knowledge.bigenius-x.com/persist-validity-project?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: [Understand the Generator target objects](https://knowledge.bigenius-x.com/understand-the-generator-target-objects?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) - [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