SQL Workbench

SQL Workbench is the in-app query editor. Open it from the Mesh Storage action bar — no credentials to manage, no client to install.

Open the workbench

From the Mesh Storage action bar, click SQL Workbench. The editor opens as a full-screen modal.

The workbench is disabled until your data lake is provisioned and you have at least one Ready file. Upload something first if you don't see results.

Layout

Three panes:

• Schema tree (left, ~20%): databases, namespaces, tables, and columns. Click a table to insert it into the editor.
• Query editor (top right): a Monaco editor with SQL syntax highlighting and autocomplete.
• Results (bottom right): tabular results with sortable columns and pagination.

You can drag the dividers to resize either pane.

Run a query

Write standard SQL referencing tables from the schema tree. Results appear in the bottom pane as you run them:

SELECT topic, count(*) AS messages
FROM "uploads"."my_recording__diagnostics"
GROUP BY topic
ORDER BY messages DESC
LIMIT 20;

The workbench uses DuckDB running in your browser — queries execute locally against the Iceberg tables, with reads streamed from object storage. Most aggregations and filters run quickly even on multi-GB files.

Export results

Click Export CSV in the top-right of the results pane to download all rows. Export bypasses the in-page row limit, so you get the full result set.

How credentials work

The workbench fetches scoped, read-only credentials for your data lake on first open. They live in memory only — refreshing the page or closing the tab clears them. There is no localStorage or sessionStorage persistence.

The credentials have a TTL of roughly 20 hours. If a session is open longer than that, the next query will refresh them automatically.

Limitations

• Read-only. No INSERT, UPDATE, DELETE, or CREATE TABLE against the data lake.
• No cross-org joins. You can only query your own org's tables.
• In-flight files don't show up. Tables only appear once the file is Ready. If you don't see your data, check the status badge.