Skip to main content
Last updated on

View the Entity Relationship Diagram

This page describes how to access the Entity Relationship Diagram (ERD) in Catalog Explorer. The ERD shows 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 Databricks. To explore how tables connect based on query data flow rather than declared constraints, use the interactive lineage graph in Catalog Explorer instead. See View data lineage using Catalog Explorer.

To access the ERD, do the following:

  1. Click Data 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.

    The ERD shows the primary and foreign key relationship between tables

The example diagram is generated from the Wanderbricks dataset, a simulated travel booking platform with users, hosts, properties, bookings, payments, reviews, and related tables. To explore the dataset, see Wanderbricks dataset.