Explore
Browse every schema, table and column you’ve connected, preview real rows, profile columns, and start a query or data model from any table.
Explore is where you find out what data you have. It lists every data source in your organization, with its schemas, tables and columns, and shows you real rows before you write a single query.
Browse your data
Open Explore in the sidebar. The tree on the left has three levels: data sources, their schemas (groups of tables), and tables. Click to open each level; tables load when you open their schema, so even very large databases stay quick.
The box above the tree filters what’s already open by name. Your place is saved in the page’s address, so a refresh, or a link you send a teammate, opens the same table.
A data source
Select a data source to see its schemas and details. Depending on the kind of source, you can also:
- New query: start a query on this data source.
- Load data (DuckDB and Postgres): turn a file into a table. See Upload files.
- New schema (DuckDB): add a schema to organize tables.
- Attachments (DuckDB): query a Postgres data source from this warehouse. See Attach a Postgres database.
A table
Select a table to see it from four angles:
| Tab | What it shows |
|---|---|
| Overview | Where the table lives, and its columns at a glance. |
| Columns | Every column with its type and whether it can be empty. |
| Profile | DuckDB only. For each column: minimum, maximum, approximate number of unique values, average, spread and the share of empty values. A quick way to spot gaps and oddities. |
| Preview Data | The first 100 rows, so you can see real values, formats and codes. |
And two actions:
- Query this table opens a new query that selects from it. Run it with ⌘↵ (Ctrl+Enter on Windows).
- Create data model drafts a data model from the table’s columns, for you to review and save.
Ask the agent instead
“What data do we have, and what does each table hold?” is a good first question for the Data Agent. It reads the same schemas and previews, and sums them up in plain words.
Something unclear or missing? Troubleshooting covers the common errors, or message us.