Skip to main content

Default Schema

The default schema to use for the Data Vault in the Accelerator.

Every object the Accelerator creates (Hubs, Links, Satellites, Link Satellites, References) is placed in a schema resolved in this order: the object-type-specific schema setting (Schema Hub, Schema Link, Schema Satellite, Schema Link Satellite) if set, otherwise this Default Schema as overridden on the source object, otherwise this Default Schema at the project level.

When to Change This Setting​

Change it when your Data Vault database uses a schema other than dv, or override it per source object (through a Settings override) to accelerate different sources into different schemas. Use the object-type-specific settings instead when Hubs, Links and Satellites should land in separate schemas.

SettingInteraction
Schema HubPer-object-type override for Hub tables
Schema LinkPer-object-type override for Link tables
Schema SatellitePer-object-type override for Satellite tables
Schema Link SatellitePer-object-type override for Link Satellite tables

Notes​

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