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. - **Git repository import.** Link a git repository to the workspace and scan it to import pipeline and script .sql files into the catalog. The scan wizard controls the selection: files you select are imported, and deselecting previously imported files removes their pipelines or scripts. The selection is persisted as import exclusions on the repository, so removed files stay removed across every pull-and-rescan while remaining untouched in git. Workspace content is managed exclusively through this scan; DeltaForge does not author workspace files. - **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, commit it to the workspace's git repository as a pipeline or script file and run the repository scan to import it into the catalog.