Entities and entries are stored in schema-specific tables in the data warehouse with columns dedicated to metadata fields and internal identifiers. You can use the schema browser and Entity Relationship Diagram to view the queryable tables in the data warehouse, and to retrieve their table names to reference in SQL queries. This article explains how to:

Search for schema tables in the schema browser

Each schema table has two versions:

  • The default version contains rows representing unarchived, reviewed, and valid entities and entries

  • The $raw version contains entities and entries of all statuses

To preview the first five rows of a table’s contents:

  1. Enter a search term into the search bar at the top of the schema browser.

  2. Click a table name.

  3. Hover over the table name and click Copy to clipboard to paste into your SQL query.

Tip: We recommend using $raw table names in SQL queries and applying filters as needed.

View relationships between tables in the data warehouse

Use the Entity Relationship Diagram (ERD) to better understand the relationships between tables in your data warehouse. To access the ERD:

  1. Hover over or click a schema in the schema browser.

  2. Click Open entity diagram.

  3. Click See more columns to expand each table.

Each table displays the table name, columns, and relationships between tables. You can also choose to modify the SQL statement in the right-side panel.

Related topics

Embedding Insights dashboards into the registry

Insights permissions overview

Managing Insights dashboards and queries

Running Insights queries

Visualizing your Insights data

Did this answer your question?