--- title: PIT_HK description: "PIT_HK is the key of a PIT row: the Hub or Link key that the satellites of the PIT belong to." --- [Skip to content](https://knowledge.bigenius-x.com/pit_hk#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) # PIT\_HK **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Vault `PIT_HK` is the key of a PIT row: the Hub or Link key that the satellites of the PIT belong to. This article was formerly titled Pit\_HK. Together with `BG_ValidFromTimestamp` it identifies one point in time of one business key. ### Objects that carry it PIT and Business PIT. Every object of these types gets the term when it is created. The generator fills the value, so you do not map it; you can change its data type in Manage Default Terms. ### Value `PIT_HK` is not calculated. The PIT Source view copies the [Hub\_HK](https://knowledge.bigenius-x.com/hub_hk?hsLang=en) or [Link\_HK](https://knowledge.bigenius-x.com/link_hk?hsLang=en) from the tables of the related satellites. It builds one row for each key and each `BG_ValidFromTimestamp` that occurs in any of these satellites. The unknown-member rows of the satellites are left out. The primary key of the PIT table consists of `BG_ValidFromTimestamp` and `PIT_HK`. For each related satellite, the row references the satellite version that is valid at that point, see [DVPIT\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/dvpit_foreignkey_identity?hsLang=en) and [DVPIT\_ForeignKey\_LoadDate](https://knowledge.bigenius-x.com/dvpit_foreignkey_loaddate?hsLang=en). The PIT Result view, which the generator builds on the PIT table, also leaves out rows whose `PIT_HK` consists of zero bytes only. ### Data type | Platform | Type | | --- | --- | | Microsoft SQL Server | `binary(20)` | | Fabric Warehouse | `varbinary(20)` | | Oracle | `RAW(20)` | | Snowflake, Snowflake dbt | `BINARY(32)` | | Databricks, Databricks dbt, Fabric Lakehouse | `binary` | The data type must match the length of the selected [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en). ### Example A PIT on Microsoft SQL Server is based on a customer Hub and has two satellites: one with the customer type, one with the address. At 11:00 only the customer type of customer 941 changes. The PIT then holds two rows for this customer (hash values shortened): ``` PIT_HK BG_ValidFrom... CUSTOMER_BG_... CUSTOMER_Hashing_BG_... 0xD2CD1706... 2026-10-27 10:00 2026-10-27 10:00 2026-10-27 10:00 0xD2CD1706... 2026-10-27 11:00 2026-10-27 11:00 2026-10-27 10:00 ``` The last two columns are the valid-from timestamps of the referenced customer type and address versions, see [DVPIT\_ForeignKey\_LoadDate](https://knowledge.bigenius-x.com/dvpit_foreignkey_loaddate?hsLang=en). `PIT_HK` is the `Hub_HK` of customer 941. ### Release differences - Generator 2.4: Snowflake uses SHA2-256 with `BINARY(32)` by default. Up to Generator 2.3 the default was `HASH` with a numeric type, see [Generators Release - 2.4.0](https://knowledge.bigenius-x.com/generators-release-2.4.0?hsLang=en). - Generator 2.2: Databricks and Fabric Lakehouse store hash values as `binary`. Up to Generator 2.0 they were `string`. ### Related articles - Reference: [Hub\_HK](https://knowledge.bigenius-x.com/hub_hk?hsLang=en), [Link\_HK](https://knowledge.bigenius-x.com/link_hk?hsLang=en), [DVPIT\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/dvpit_foreignkey_identity?hsLang=en), [DVPIT\_ForeignKey\_LoadDate](https://knowledge.bigenius-x.com/dvpit_foreignkey_loaddate?hsLang=en), [BG\_ValidFromTimestamp](https://knowledge.bigenius-x.com/bg_validfromtimestamp?hsLang=en), [Hash Algorithm (Project)](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en) - See also: [PIT](https://knowledge.bigenius-x.com/create-a-pit?hsLang=en), [Business PIT](https://knowledge.bigenius-x.com/create-a-business-pit?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