Query Console

Query Console is the main OL DataIQ workspace for executing SQL and inspecting result sets.

Layout

• Left sidebar: Tables, metadata, and stored procedures
• Main area: SQL editor and result grid
• Header: Current connection information and navigation

Run a query

1. Enter a SQL statement in the editor.
2. Select Execute Query (or use the configured keyboard shortcut).
3. Review results in the grid below the editor.

The grid displays row count and execution time. For large tables, use LIMIT or your database equivalent to keep result sets manageable.

Common actions

• Select a table in the sidebar to generate SELECT * FROM table_name.
• Clear the editor.
• Open query history or saved queries.
• Create an API from a successful query when Hub is configured.

See the child topics for autocomplete, editing, AI assistance, and result-grid controls.