Tutorial: Databricks SQL warehouse editor¶
CSA Loom
databricks-sql-warehouseeditor — verified working against a live console by the UAT harness on 2026-07-01.
Open the editor¶
- Sign in to your CSA Loom Console (for example
https://<your-console-host>). - Open or create a workspace from the Workspaces page.
- Click + New item and choose Databricks SQL warehouse from the catalog.
- The editor opens at
/items/databricks-sql-warehouse/<id>:
What this editor does¶
A Databricks SQL warehouse is a serverless or classic SQL endpoint over Delta Lake with Unity Catalog and Photon. In Loom it lists real warehouses and runs statements via /api/2.0/sql against the Loom-deployed workspace.
Getting started¶
- Start a warehouse — Lists real warehouses; start/stop via the /start and /stop endpoints.
- Browse Unity Catalog — Run SHOW CATALOGS/SCHEMAS/TABLES to navigate governed data.
- Run SQL — Execute statements via /api/2.0/sql/statements with result polling.
- Connect BI tools — Point Power BI, Tableau, or Excel at the warehouse via JDBC/ODBC.
Learn more¶
- Microsoft Learn reference: https://learn.microsoft.com/azure/databricks/sql/admin/sql-endpoints
Verified by the UAT harness¶
- Tested at:
2026-05-26T13:53:36.426Z - Verdict: A (renders cleanly, real backend responded)
- Test source:
apps/fiab-console/e2e/editors.uat.ts
