Isolated development environments with integrated SQL editor, file explorer, and pipeline management.
## Overview The Workspaces page is the primary development environment where data engineers and analysts write, test, and execute SQL against the DeltaForge catalog. Each workspace provides an isolated context with its own set of associated zones, an integrated SQL editor with language-server support, a catalog tree explorer, query history, and a favorites system for frequently accessed objects. Workspaces serve as the day-to-day operational surface for interactive data exploration, pipeline development, and ad-hoc analysis. Pipelines belong to a workspace, and all SQL execution occurs within the scope of a workspace's associated zones and schemas. ## Key Features - **Workspace creation and management.** Create named workspaces, configure their zone associations, and remove workspaces that are no longer needed. Each workspace isolates its catalog scope so that users see only the zones and schemas relevant to their work. - **Integrated SQL IDE.** Write and execute SQL statements in a full-featured editor with syntax highlighting, auto-completion, and inline error diagnostics powered by the language server protocol (LSP). Query results render in a virtual-scrolling table that handles large result sets efficiently. - **Zone/schema/table tree explorer.** Browse the catalog hierarchy (zones, schemas, tables, columns) in a collapsible tree panel. Click any table to view its schema, preview data, or insert a qualified reference into the SQL editor. - **Query history.** Access a chronological log of all SQL statements executed within the workspace. Re-run previous queries, copy them into the editor for modification, or use them as a reference when building new transformations. - **Favorites.** Bookmark frequently used tables, views, scripts, or queries for quick access. Favorites appear in a dedicated panel and persist across sessions. ## Workflow 1. Open the Workspaces page from the Workflow sidebar. 2. Select an existing workspace or create a new one with the desired zone associations. 3. Use the tree explorer to browse available schemas and tables. 4. Write SQL in the integrated editor, leveraging auto-completion and inline diagnostics. 5. Execute the query and review results in the virtual-scrolling result table. 6. Bookmark frequently used objects to the favorites panel for quick access. 7. Review query history to locate and re-run previous statements. 8. When a transformation is finalized, promote it to a pipeline or save it as a reusable script.