Skip to main content

Worksheets Overview

If you spend most of your day writing and iterating on SQL, worksheets are where that happens. Each worksheet holds a query plus its full context: compute cluster, catalog, database namespace, and any query variables. That context persists between sessions, so you pick up right where you left off.

You organize worksheets in a three-level hierarchy (Workspaces > Folders > Worksheets), structured however fits your team. Beyond basic query editing, worksheets support:

Workspaces and Folders

Worksheets are organized in workspaces. See Workspaces for details on creating workspaces, managing folders, and permissions.

SQL Editor layout with sidebar workspace tree, open worksheet tab, code editor, and results panel | IOMETESQL Editor layout with sidebar workspace tree, open worksheet tab, code editor, and results panel | IOMETE

Getting Started

The home screen gets you from zero to a working worksheet in one click. When you first open the SQL Editor with no worksheets, you'll see three options:

  1. New worksheet: creates a worksheet in your personal workspace
  2. Import file: opens a file picker for .sql, .dash, or .ipynb files
  3. Add Git repository: takes you to Settings > Git Repository to connect a repository

Already have open tabs? The editor skips the home screen and takes you straight to your last-visited worksheet.

SQL Editor home screen with New worksheet, Import file, and Add Git repository buttons | IOMETESQL Editor home screen with New worksheet, Import file, and Add Git repository buttons | IOMETE

Working with Worksheets

Once you have a few worksheets, you'll want to keep them organized. The sidebar's right-click context menu is the main hub for creating, moving, renaming, and cleaning up worksheets.

Creating a Worksheet

Two paths lead to a new worksheet.

From the sidebar: Right-click any workspace or folder node, select New worksheet, type a name in the inline input, and press Enter.

From the home screen: Click New worksheet, enter a Worksheet name (required, max 100 characters) in the modal, and confirm. Home-screen worksheets land in My Workspace.

Character Restrictions

Worksheet names can't contain these special characters: / \ : * ? " < > |

Workspace context menu with New worksheet, New dashboard, and New folder options | IOMETEWorkspace context menu with New worksheet, New dashboard, and New folder options | IOMETE

Opening a Worksheet

Click any worksheet in the sidebar to open it as a tab. Each tab is divided into four areas:

  • Toolbar at the top (run button, compute selector, collaboration avatars, and more)
  • An optional Query variables bar
  • The Code editor
  • A resizable Results panel at the bottom
Open worksheet showing toolbar, code editor with SQL, and results panel with data grid | IOMETEOpen worksheet showing toolbar, code editor with SQL, and results panel with data grid | IOMETE

Renaming, Duplicating, and Moving Worksheets

Right-click the worksheet node in the sidebar to access these actions:

  • Rename: Select Rename, edit the inline text, and press Enter.
  • Duplicate: Select Duplicate to create a copy in the same folder.
  • Move to / Copy to: Browse workspaces and folders in the multi-column navigator to pick a destination. Moving requires MOVE permission; copying requires PUT permission on the target workspace.
Worksheet right-click context menu with Rename, Duplicate, Move to, Copy to, and Delete options | IOMETEWorksheet right-click context menu with Rename, Duplicate, Move to, Copy to, and Delete options | IOMETE

Importing a File

If you have existing .sql, .dash, or .ipynb files, you can import them as worksheets. Right-click a workspace node and select Import file, or use the Import file button on the home screen. The new worksheet takes the file's name and content. Home-screen imports land in My Workspace.

Workspace context menu showing the Import file option | IOMETEWorkspace context menu showing the Import file option | IOMETE

Deleting a Worksheet

Right-click the worksheet node and select Delete (shown in red). If the worksheet has content, a confirmation dialog appears. Click Force delete to proceed.

Permanent Deletion

Deleting a worksheet permanently removes it and its contents. This can't be undone.

Worksheet context menu with Delete option highlighted in red | IOMETEWorksheet context menu with Delete option highlighted in red | IOMETE

Keyboard Shortcuts

ActionMacWindows / Linux
Run queryCmd+EnterCtrl+Enter
Save worksheetCmd+SCtrl+S
Open autocompleteCmd+SpaceCtrl+Space