Skip to content
  • There are no suggestions because the search field is empty.

Wizard step - Create Multiple Relations Driving or Not Driving

Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle
Architecture: Data Vault

Create Multiple Relations Driving and Not Driving are two steps of the Create Driving Key Link and Create Business Driving Key Link wizards. In them, you select the Hubs whose relationships drive the link and those that do not. Earlier versions of this article called the steps Create Relations Driving and Create Relations Not Driving.

Create Multiple Relations Driving or Not Driving

Both wizards have the steps Create Model Object, Create Dataflow, Create Multiple Relations Driving, Define Roles, Create Multiple Relations Not Driving, Define Roles, Map Foreign Key Terms and Add to View.

Each relation step lists the model objects that the link can reference, with a search box:

  • Create Multiple Relations Driving, "Select Hub(s) Driving the Relationship": the relationships it creates have Driving Key true.
  • Create Multiple Relations Not Driving, "Select Hub(s) not Driving the Relationship": the relationships it creates have Driving Key false.
  1. In Create Multiple Relations Driving, tick the Hubs that drive the relationship and choose CREATE RELATIONSHIPS.
  2. In the following Define Roles step, check the role names and choose DEFINE ROLES.
  3. In Create Multiple Relations Not Driving, tick the other Hubs and choose CREATE RELATIONSHIPS.
  4. Check their role names in the second Define Roles step.

To change Driving Key after the wizard, see Edit a Relationship.

Related articles