Auto-relationships

Data modules now support automatic creation of new relationships, called auto-relationships, between tables from different data sources. The auto-relationships are discovered and generated with minimal effort from the modeler.

By using auto-relationships, you can avoid the manual effort of identifying the related tables and connecting them. For example, when adding new uploaded files to a schema-based data module, you can establish relevant relationships throughout the data module with just a single click.

You can initiate the discovery action from the Relationships diagram or from the metadata tree. Select one or multiple tables, and from their context menu , click Auto-relationships.

When the relationship discovery is successfully completed, a toast message shows the number of generated relationships, and the new relationships are visible in the relationship diagram. To accept the auto-generated relationships, save the data module.

Tip: You can use the undo and redo buttons in the application bar to revert or restore your changes.

For more information, see Generating auto-relationships.