Search for schemas to use in Insights queries

  • Updated

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. You can also view documentation on various warehouse tables in our developer documentation.

This article explains how to search for schema tables in the schema browser, and how to view relationships between tables in the data warehouse. 

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.

Was this article helpful?

Have more questions? Submit a request