Skip to content
CSA Loom — the Microsoft Fabric experience for Azure tenants where Fabric isn't yet available: lakehouses, warehouses, notebooks, semantic models, Activator rules, Data Agents, across Commercial, GCC, GCC-High, and DoD IL5

Tutorial: Synapse dedicated SQL pool editor

CSA Loom synapse-dedicated-sql-pool editor — verified working against a live console by the UAT harness on 2026-07-01.

Open the editor

  1. Sign in to your CSA Loom Console (for example https://<your-console-host>).
  2. Open or create a workspace from the Workspaces page.
  3. Click + New item and choose Synapse dedicated SQL pool from the catalog.
  4. The editor opens at /items/synapse-dedicated-sql-pool/<id>:

Synapse dedicated SQL pool editor

What this editor does

A Synapse dedicated SQL pool is a provisioned MPP T-SQL warehouse (formerly SQL DW). In Loom it is wired via ARM REST for pause/resume and TDS query on workspace.sql.azuresynapse.net through the Console MI. It auto-pauses to control cost.

Getting started

  1. Resume the pool — Resume from the editor; the first query blocks until the pool reaches Online (about 60-90 seconds).
  2. Run T-SQL — Use Run query to issue T-SQL; Recent runs shows execution history and DMV stats.
  3. Scale for load — Raise the SLO/DWU level temporarily for high-concurrency loads — billing scales with the SLO.
  4. Pause when idle — Pause the pool when not running ELT; paused pools incur storage cost only, and a built-in auto-pause Logic App suspends it after the idle window.

Learn more

Verified by the UAT harness