Skip to main content
Integrator+Needs connector

Explore your data

Browse the schemas and tables inside a connected database, check their columns and indexes, and preview a few rows. Exploring is read-only: nothing you do here changes your database.

Before you begin​

You need:

Open a connector’s schema​

  1. Open Data Models from the sidebar.

    The page lists your connectors. Each row shows the number of schemas and tables, or Schema unavailable, and the connector's health status.

    The Data Models page listing five connectors, each with its schema and table count or Schema unavailable, and a Connected or Connection failed status

  2. Select a connector.

    Its schema opens. The header shows the connector name, the number of schemas and tables, and an Edit connector button.

    The schema of the Orders Warehouse connector, with the schema tree on the left and the Columns tab of the orders table on the right

You can also open a schema from the Connectors page: open the ⋮ menu on a connector's row and select Explore schema. When you add a new connector, its schema opens on its own.

If the connector's last test failed, a banner says the connection is failing health checks and shows the last known schema. Fix the connection to browse live data. See Test the connection.

Browse schemas and tables​

The tree on the left shows the database, its schemas with the number of tables in each, and the tables, views and objects inside them. The first table opens on its own.

  1. Select a database or schema to expand or collapse it.

  2. To find a table, type in Search tables….

    The tree expands and shows only the tables whose name matches.

    The schema tree filtered by order in Search tables…, showing only the order_items and orders tables

  3. Select a table to inspect it.

If nothing matches, the tree shows No tables match followed by your search. If the database has no tables, it shows No tables found for this connector.

Columns, indexes and preview​

The panel on the right shows the selected table's name, whether it's a Table, View or Object, its schema and its number of columns. It has three tabs:

TabWhat it shows
ColumnsEach column with its data type. Columns that can be empty are marked nullable.
IndexesEach index with its columns. The primary key is marked primary, and unique indexes unique.
PreviewUp to 6 sample rows read live from the database.

  1. Select Indexes to see the table's indexes.

    If it has none, the tab shows No indexes found on this table.

    The Indexes tab of the orders table, with orders_pkey marked primary and orders_order_number_key marked unique

  2. Select Preview to see sample rows.

    The header now also shows the number of rows. If the table is empty, the tab shows Table is empty — no sample rows available.

    The Preview tab of the orders table, with six sample rows and the row count in the header

note

The explorer reuses a table list for up to 5 minutes, and a table's indexes and preview for up to 60 seconds. To see changes you just made in your database, reload the page.

If the schema doesn't load, the page shows Could not load schema. or an error that starts with Schema introspection failed. Test the connector and fix its connection details. See Test the connection.