Importing Table Relationships

Overview

You can enrich context with referential integrity (RI) relationships allowing downstream workflows understand how tables connect. Relationships can be automatically from read from a connected source.

• Auto-import from supported databases – Promethium discovers RI metadata when you connect a source that supports this capability. Supported sources are;
  • Snowflake
  • SQL Server
  • PostgreSQL

Automatic Relationship Import

1. Ensure primary and foreign keys are defined in the source so they appear in the metadata.
2. Add your data source to Promethium.
3. Save the connection. Promethium ingests the RI information and keeps it refreshed on the schedule you define.

Use this option whenever the source system already maintains reliable constraints and you simply want that knowledge available in Promethium.