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 or feed into the system with a YAML file.

Import Options

• 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
• Manual YAML upload – provide your own join definitions when you want full control or need to supplement what was discovered.

Automatic Context 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.

Manual YAML Upload

Upload a YAML file when you have business-approved join logic or when constraints are not stored in the database. The file must contain a rules array with one entry per relationship.

Rule fields

Field	Required	Description
rule	Yes	Human-readable join instruction between two or more tables. Use fully qualified table names for clarity.
id	No	Only include if you want future uploads to replace an existing rule with the same external identifier.

rules:
  - id: id1
    rule: >
      table snowflake.CUSTOMER_DEMO.DIM_PRODUCT INNER JOIN snowflake.CUSTOMER_DEMO.FACT_SALES on DIM_PRODUCT_X01 = FACT_SALES_X02
  - rule: >
      table postgres.test.authors INNER JOIN postgres.test.books on author_id = author_id