Change References To Integration Key
Determines if the Import Metadata feature adds derived Integration Keys based on source references, or use source columns for references.
When enabled (the default), importing a table whose columns reference another table adds a derived reference key column with a FlexToBk expression matching the referenced object's Integration Key, so references resolve through Integration Keys rather than the raw source columns. When disabled, references stay on the source columns as imported.
This setting provides the default for the Create Integration Key References option in the Import Metadata dialog and can be overridden per connection or project.
When to Change This Setting
Keep the default Y for Data Vault-style modeling, where relationships between objects are expressed through Integration Keys (this is what drives Link and reference resolution downstream). Disable it when you want imported metadata to mirror the source's foreign key columns without derived key columns.
Related Settings
| Setting | Interaction |
|---|---|
| Infer Integration Key From | Determines how the Integration Key itself is derived during import |
| FlexToBk on Reference | Validation that reference columns define a FlexToBk expression |
| Append Integration Key | The affix used to name derived key columns |
Notes
- This setting is part of the Model settings category.
- The default value for this setting is
Y.