Skip to main content

Append Surrogate Key

The string to append to Surrogate/Hash Key column names.

The Accelerator derives surrogate key column names for Hubs, Links and Link Satellites by combining the object's derived name with this affix, joined by the Column Separator and positioned according to the Suffix Or Prefix Column setting — with the default suffix behavior, the Customer Hub's key column is Customer_SK. Whether the object-type affix (HUB/LNK) is included in that derived name is controlled by Prefix Surrogate Key.

The affix applies when the model uses hash or sequence keys; for a natural-keyed Data Vault the Append Integration Key affix is used instead.

When to Change This Setting​

Change it to match your naming standard for surrogate/hash key columns (for example HK for hash key). Set it before accelerating — the affix is baked into column names when the Accelerator creates them.

SettingInteraction
Suffix Or Prefix ColumnDetermines whether the affix is prepended or appended
Prefix Surrogate KeyControls whether the Hub/Link object affix is included in the key name
Append Integration KeyThe affix used instead when the model does not use hash or sequence keys
Use Hash KeysDetermines whether the Data Vault uses hash keys at all

Notes​

  • This setting is part of the Data Vault Naming settings category.
  • The default value for this setting is SK.