--- title: Driving Key Link description: A Driving Key Link is a Link with a second hash key, DrivingKeyLink_HK, calculated from the relationships marked as driving key. --- [Skip to content](https://knowledge.bigenius-x.com/create-a-driving-key-link#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) # Driving Key Link **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Vault A Driving Key Link is a Link with a second hash key, `DrivingKeyLink_HK`, calculated from the relationships marked as driving key. Use it when one side of a relationship decides which relationship is current, for example an employee who has exactly one job function at a time. A Link Satellite on the Driving Key Link then closes the previous relationship of the employee when a new one arrives. ### Sources and relationships A Driving Key Link reads [Stages](https://knowledge.bigenius-x.com/create-a-stage?hsLang=en), [RawVault Composites](https://knowledge.bigenius-x.com/create-a-raw-vault-composite?hsLang=en) and [Store Entities](https://knowledge.bigenius-x.com/create-a-store-entity?hsLang=en) of a linked Data Store project, in one or more dataflows. It has at least two relationships to [Hubs](https://knowledge.bigenius-x.com/create-a-hub?hsLang=en). The relationship property [Driving Key](https://knowledge.bigenius-x.com/driving-key-relationship?hsLang=en) marks the driving side; its default is true, so set it to false on the other relationships. The foreign-key terms are the business keys of the Driving Key Link. Link Satellites, Record Tracking Link Satellites, Effectivity Link Satellites reference a Driving Key Link. PIT, Current View, History View, BusinessVault Composite, [Vault Out](https://knowledge.bigenius-x.com/create-a-vault-out?hsLang=en) and the Business Vault types can read it as a source. ### Create the model object - With the wizard: open the menu of a Stage, RawVault Composite or Store Entity, choose **Automate** and then **Create Driving Key Link**. 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), [Create Multiple Relations Driving](https://knowledge.bigenius-x.com/wizard-step-create-relations-driving-or-not-driving?hsLang=en), [Define Roles](https://knowledge.bigenius-x.com/wizard-step-create-relations-with-role?hsLang=en), [Create Multiple Relations Not Driving](https://knowledge.bigenius-x.com/wizard-step-create-relations-driving-or-not-driving?hsLang=en), Define Roles, [Map Foreign Key Terms](https://knowledge.bigenius-x.com/wizard-step-map-foreign-key-terms?hsLang=en) and [Add to View](https://knowledge.bigenius-x.com/wizard-step-add-to-view?hsLang=en). The two relation steps are described in [Wizard step - Create Multiple Relations Driving or Not Driving](https://knowledge.bigenius-x.com/wizard-step-create-relations-driving-or-not-driving?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 Driving Key Link in the Raw Vault layer, [add a relationship](https://knowledge.bigenius-x.com/add-a-relationship?hsLang=en) to each Hub and set Driving Key, [create a dataflow set](https://knowledge.bigenius-x.com/create-a-data-flow-set?hsLang=en), [add the source model object](https://knowledge.bigenius-x.com/add-a-model-object-into-a-data-flow-set?hsLang=en) and [map the foreign-key terms](https://knowledge.bigenius-x.com/map-a-source-term-with-a-target-term?hsLang=en). ### Properties - [Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en): `Permanent` only. - [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en): whether the table gets foreign keys to the Hub tables. With `Create Disabled`, the default, they are created and disabled. - [Load Caching](https://knowledge.bigenius-x.com/load-caching-model-object?hsLang=en): empty (default) or `Hashing`, which stores the hashing view in a table before the loader runs. - [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en): values of the unknown-member row. - [Deduplication Method](https://knowledge.bigenius-x.com/deduplication-method-model-object?hsLang=en) and [Sort Order within Partition](https://knowledge.bigenius-x.com/deduplication-partition-model-object?hsLang=en), per dataflow. - [Driving Key](https://knowledge.bigenius-x.com/driving-key-relationship?hsLang=en), per relationship: `true` (default) or `false`. - [Use Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en), per relationship: inserts business keys that the Hub does not hold yet. ### Default Terms - [`Link_HK`](https://knowledge.bigenius-x.com/link_hk?hsLang=en): hash of the business keys of all relationships and primary key of the table. - [`DrivingKeyLink_HK`](https://knowledge.bigenius-x.com/drivingkeylink_hk?hsLang=en): hash of the business keys of the driving relationships. With one driving relationship to a Hub, it equals that Hub's key. - [`DVLINK_ForeignKey_Identity`](https://knowledge.bigenius-x.com/dvlink_foreignkey_identity?hsLang=en): names one hash-key column per relationship, `__HK`, with the key of the related Hub row. - [`BG_LoadTimestamp`](https://knowledge.bigenius-x.com/bg_loadtimestamp?hsLang=en) and [`BG_SourceSystem`](https://knowledge.bigenius-x.com/bg_sourcesystem?hsLang=en): the load that inserted the row and its source system, empty unless you map it. - [`BG_DataQuality_ID`](https://knowledge.bigenius-x.com/bg-dataquality-id?hsLang=en), [`BG_ErrorCount`](https://knowledge.bigenius-x.com/bg_errorcount?hsLang=en) and [`BG_ErrorDescription`](https://knowledge.bigenius-x.com/bg_errordescription?hsLang=en): hidden terms of the data quality objects. See [How biGENIUS-X builds hash values](https://knowledge.bigenius-x.com/how-bigenius-x-builds-hash-values?hsLang=en). ### Generated objects These are the names on Microsoft SQL Server for the Driving Key Link `load_dkl` with one dataflow: | Role | Generated name | Purpose | | --- | --- | --- | | Source | `RDV_DKLNK_load_dkl_Source` | Reads the sources | | Deduplication | `RDV_DKLNK_load_dkl_Deduplication` | Removes duplicate rows | | Hashing | `RDV_DKLNK_load_dkl_Hashing` | Calculates the hash keys | | HashingStorage | `RDV_DKLNK_load_dkl_HashingTable` | Stores the hashed rows | | HashingLoader | `RDV_DKLNK_load_dkl_HashingLoader` | Fills the hashing table | | EmbryoLoader | `RDV_DKLNK_load_dkl_EmbryoLoader` | Adds missing Hub keys | | Delta | `RDV_DKLNK_load_dkl_Delta` | Selects new key combinations | | Loader | `RDV_DKLNK_load_dkl_Loader` | Inserts the new rows | | Storage | `RDV_DKLNK_load_dkl` | Driving Key Link table | | Result | `RDV_DKLNK_load_dkl_Result` | Query view | - Loaders are stored procedures; the Driving Key Link table and the hashing table are tables; all other objects are views. - The deduplication view exists only with a Deduplication Method other than `None`. - The hashing table and hashing loader exist only with Load Caching `Hashing`. The delta view then reads the hashing table. - The embryo loader exists only when Use Embryo Loader is true on a relationship. It runs before the loader. - With several dataflows, all objects except the table and the result view exist once per dataflow, with the dataflow name in their names, for example `RDV_DKLNK_load_dkl_Dataflow1_HashingTable`. - The table script inserts the unknown-member row with hash keys of zeros. The result view hides it. - When no other model object has a relationship to the Driving Key Link, its result view shows only the latest row per `DrivingKeyLink_HK`. - The result view always exists, independent of [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en). With the default settings, a load runs this chain: ``` sources -> _Source -> _Hashing -> _Delta -> _Loader _Loader -> RDV_DKLNK_load_dkl -> _Result _Result -> _Delta (key combinations already stored) ``` The hashing view calculates `Link_HK`, `DrivingKeyLink_HK` and one Hub key per relationship. The delta view keeps the rows whose `Link_HK` is not in the result view, and the loader inserts them. The Driving Key Link itself never updates or deletes rows: it keeps the earlier relationship as well. Its Link Satellites store which relationship is current: - The Link Satellite carries `DrivingKeyLink_HK` next to `Link_HK`. - Its row hash includes the business keys of the relationships that are not driving. - Its validity ends per `DrivingKeyLink_HK`. A new relationship of the same driving key therefore ends the version of the previous relationship. With the optional objects, `_Deduplication` sits between `_Source` and `_Hashing`, `_HashingLoader` fills `_HashingTable` before the delta view reads it, and `_EmbryoLoader` writes missing keys to the Hub tables. ### Example The Driving Key Link `load_dkl` on Microsoft SQL Server reads the Stage `EMPLOYEE`. Its relationship to the Hub `common_employee` (role `EMPLOYEE`) is driving; the one to the Hub `common_jobfunction` (role `jobfunction`) is not. The Link Satellite `load_employee_dklsat_1` stores `MANAGER_ID` and other employee data. The loads deliver these rows: - Load 1 on 2026-10-28 08:00: employee 101 with job function 10, employees 102 and 103 with job function 20 and manager 101. - Load 2 on 2026-10-29 08:00: employee 102 moves to job function 30, employee 103 gets manager 102, and employee 104 is new with job function 10 and manager 102. ### Check the result Query the Driving Key Link, here in the schema `rv`: ``` SELECT FK_common_employee_EMPLOYEE_EMPLOYEE_ID AS EMPLOYEE_ID, FK_common_jobfunction_jobfunction_JOBFUNCTION_ID AS JOB_ID, Link_HK, DrivingKeyLink_HK, BG_LoadTimestamp FROM rv.RDV_DKLNK_load_dkl_Result ORDER BY EMPLOYEE_ID, BG_LoadTimestamp; ``` This is the result after load 2, with hash keys shortened to their first four bytes: ``` EMPLOYEE_ID JOB_ID Link_HK DrivingKeyLink_HK BG_LoadTimestamp 101 10 0xF5A3FB96 0x6348AE9A 2026-10-28 08:00 102 20 0x7253958A 0x8887BDD9 2026-10-28 08:00 102 30 0xBF5A86A3 0x8887BDD9 2026-10-29 08:00 103 20 0x30ED23FA 0x9D4E8CB4 2026-10-28 08:00 104 10 0x542F37C7 0x01656192 2026-10-29 08:00 ``` Then query the Link Satellite with the keys of the Driving Key Link: ``` SELECT l.FK_common_employee_EMPLOYEE_EMPLOYEE_ID AS EMPLOYEE_ID, l.FK_common_jobfunction_jobfunction_JOBFUNCTION_ID AS JOB_ID, s.MANAGER_ID, s.BG_ValidFromTimestamp, s.BG_ValidToTimestamp FROM rv.RDV_LSAT_load_employee_dklsat_1_Result AS s JOIN rv.RDV_DKLNK_load_dkl_Result AS l ON l.Link_HK = s.Link_HK ORDER BY EMPLOYEE_ID, s.BG_ValidFromTimestamp; ``` This is the Link Satellite after load 2, with the column names shortened: ``` EMPLOYEE_ID JOB_ID MANAGER_ID ValidFrom ValidTo 101 10 NULL 2026-10-28 08:00 9999-12-31 00:00 102 20 101 2026-10-28 08:00 2026-10-29 08:00 102 30 101 2026-10-29 08:00 9999-12-31 00:00 103 20 101 2026-10-28 08:00 2026-10-29 08:00 103 20 102 2026-10-29 08:00 9999-12-31 00:00 104 10 102 2026-10-29 08:00 9999-12-31 00:00 ``` - Employee 102 has two rows in the Driving Key Link with the same `DrivingKeyLink_HK`. The result view shows both, because the Link Satellite has a relationship to the Driving Key Link. - In the Link Satellite, the version with job function 20 ends at load 2, when job function 30 starts. Only one version per employee is open. - Employee 103 keeps job function 20; the new manager starts a new version of the same relationship. ### Platform differences - Snowflake: names are in capitals, and the loader is a stored procedure. The load control task `LC_RDV_DKLNK__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 is the notebook `RDV_DKLNK__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), [Optimization Method Columns](https://knowledge.bigenius-x.com/optimization-method-columns-model-object?hsLang=en) and [Use Sequential Dataflow Execution](https://knowledge.bigenius-x.com/use-sequential-dataflow-execution-model-object?hsLang=en) apply. Fabric Lakehouse allows only Foreign Key Mode `None`. - Databricks dbt and Snowflake dbt: the Driving Key Link becomes the dbt models `rdv_dklnk__source` and `rdv_dklnk_`. The model `rdv_dklnk__result` exists only when Create Result Views is true; the default on dbt is false. Load Caching and Use Embryo Loader are not available. - Fabric Warehouse: the same objects as on Microsoft SQL Server, deployed by notebooks. - Oracle: names are in capitals, and the loader 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. - Foreign Key Mode `Create Enforced` exists only on Microsoft SQL Server and Oracle. ### Limitations - A Driving Key Link has at least two relationships and no terms other than foreign keys and Default Terms. - The Driving Key Link alone does not show which relationship is current. Its Link Satellite shows it. - A dataflow that delivers the same key combination twice in one load makes the loader fail with a primary key violation. A Deduplication Method removes such duplicates before hashing. ### Release differences - Generator 2.2: Use Embryo Loader is available. - Generator 2.3: Custom Singleton Values is available. - Generator 2.4: Link Satellites of a Driving Key Link end their versions per `DrivingKeyLink_HK`. - Generator 2.4.1: with Load Caching `Hashing` and several dataflows, each dataflow has its own hashing table, named with the dataflow. ### Related articles - Previous: [Hub](https://knowledge.bigenius-x.com/create-a-hub?hsLang=en) - Next: [Link Satellite](https://knowledge.bigenius-x.com/create-a-link-satellite?hsLang=en) - Reference: [DrivingKeyLink\_HK](https://knowledge.bigenius-x.com/drivingkeylink_hk?hsLang=en), [Link\_HK](https://knowledge.bigenius-x.com/link_hk?hsLang=en), [DVLINK\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/dvlink_foreignkey_identity?hsLang=en), [Driving Key (Relationship)](https://knowledge.bigenius-x.com/driving-key-relationship?hsLang=en), [Foreign Key Mode (Model Object)](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en), [Load Caching (Model Object)](https://knowledge.bigenius-x.com/load-caching-model-object?hsLang=en), [Custom Singleton Values (Model Object)](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en), [Create Result Views (Project)](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) - See also: [Link](https://knowledge.bigenius-x.com/create-a-link?hsLang=en), [Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en), [How biGENIUS-X builds hash values](https://knowledge.bigenius-x.com/how-bigenius-x-builds-hash-values?hsLang=en), [Create a Model Object with the wizard](https://knowledge.bigenius-x.com/create-a-model-object-with-the-wizard?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