Share via

View the Entity Relationship Diagram

  • Article

This article describes how to access the Entity Relationship Diagram (ERD) in Catalog Explorer. The ERD displays the primary key and foreign key relationships between tables in a graph, providing a clear and intuitive representation of how data entities connect. You can access the ERD from Catalog Explorer when viewing any table that contains a foreign key constraint.

For more information about primary key and foreign key constraints, see Constraints on Azure Databricks.

To access the ERD, do the following:

  1. Click Catalog icon Catalog in the sidebar.

  2. Select a schema.

  3. Select a table with foreign keys defined. Primary key pill and Foreign key pill icons appear next to columns that are designated as primary keys or foreign keys.

    Table schema

  4. Click View relationships View relationships button above the table in the Description section of the Overview tab to open the ERD.

    ERD