how-to-guides

No menu items for this category

Table Constraint

​In OpenMetadata, table constraint are integral to understanding the relationships between tables, enhancing data discovery, and facilitating comprehensive data lineage tracking. By default, the ingestion process captures these constraints, allowing users to visualize and manage table relationships effectively.​

Once the metadata ingestion is complete, foreign key relationships can be explored within the OpenMetadata UI:​

Once the metadata ingestion is complete, foreign key relationships can be explored within the OpenMetadata UI:​

  • Access the desired table within the OpenMetadata interface.
Navigate to the Table Details Page

Navigate to the Table Details Page

Explore Table Constraints

Explore Table Constraints

This visualization aids in understanding data dependencies and supports effective data governance.​

To modify table constraint:​GitHub

  • Confirm that you have the necessary edit permissions for the table.​
  • Navigate to the table's schema view within the OpenMetadata UI.​
Access the Table's Schema

Access the Table's Schema

  • Edit the table constraint as required.​
Modify Constraints

Modify Constraints

If the editing options are unavailable, it may indicate insufficient permissions or that the feature is not supported in your current OpenMetadata version. In such cases, consider upgrading to the latest version or consulting your administrator.​