Skip to Content
Data VaultTablesQuery Explorer

Query Explorer

By the end of this page you will be able to write and run a SQL query against your tables, read its results and plan, parameterize it, and save it to reuse later.

Prerequisites

Open Data Vault → Tables → Query Explorer. It has a SQL editor in the center, a Saved Queries panel on the left, and a Validation / Params / Plan panel on the right. Badges in the header show the SQL dialect and the current schema.

Query Explorer with the SQL editor, results panel, and the validation/params/plan side panel
⚠️

Query Explorer runs read-only SELECT queries. To change data, use the table grid, import, or the Data Assistant.

Write and run a query

Write your SQL

Type a SELECT in the editor. Schema-aware autocomplete suggests your tables and columns as you type.

Validate (optional)

Validate the query to check it before running. The Validation tab shows whether the SQL is valid and flags anything that isn’t allowed.

Run it

Run the query. Results appear in the Results panel below the editor, with the returned row count.

Query results panel showing returned rows and a row count

Export the results

Click the export action in the Results panel to download the returned rows as CSV.

Inspect the query plan

Click Explain in the toolbar to see the database’s execution plan for your query in the Plan tab — useful for understanding how a query runs before you rely on it.

Use parameters

Write parameter placeholders in your SQL and manage them in the Params tab, supplying test values there. Parameters let you reuse the same query with different inputs.

Save and reuse queries

Save a query

Click Save, give the query a name, and it appears in the Saved Queries panel. When a saved query is open, the button becomes Update.

Run or manage saved queries

From the Saved Queries panel, load a query back into the editor, run it directly, or delete it.

Saved Queries panel listing saved queries with load, run, and delete actions

Common issues

  • The query is blocked — Query Explorer allows read-only SELECTs. Statements that write data or touch disallowed tables are rejected; the Validation tab explains why.
  • No autocomplete suggestions — confirm the correct schema is selected in the header; suggestions come from that schema’s tables.
  • Results look cut off — large result sets are truncated for display. Narrow the query or add a LIMIT.

Next

ER diagramData Assistant