SQL Editor Overview
The SQL Editor is IOMETE's browser-based environment for writing, running, and visualizing SQL queries. It connects to your compute clusters, supports real-time collaboration, and integrates with Git for version-controlled SQL files.
Editor Layout
The interface is split into three panels, so you can browse your catalog, write queries, and review results without switching views.
- Left sidebar (collapsible): three tabs for Worksheets (workspace tree), Explorer (catalog, namespace, table, and column browser), and Query History (previously run queries).
- Main content area: a tab bar for open worksheets, plus the active worksheet's code editor and toolbar.
- Results panel (bottom, resizable): renders query output as a data grid, chart, or raw SQL.
Key Concepts
Four building blocks make up the SQL Editor.
- Workspace: a top-level container with its own storage configuration, bundle, and permissions.
- Folder: organizes worksheets inside a workspace. Supports nesting.
- Worksheet: a SQL document that stores queries, compute cluster selection, catalog/namespace, and variables.
- Dashboard: a
.dashfile that renders as a visual dashboard inside the editor.
Feature Guides
Each guide below covers a specific part of the SQL Editor in detail.
| Guide | What It Covers |
|---|---|
| Workspaces | Creating workspaces, managing folders, access permissions, storage integration |
| Worksheets | Creating/editing worksheets, running queries, variables, charts, collaboration, Git worksheets |
| Database Explorer | Browsing catalogs, namespaces, tables, and columns |
| Query History | Viewing and reusing previously run queries |
| Dashboards | Building and managing dashboards |
| Scheduling | Scheduling queries to run automatically |