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: Azure SQL database editor

CSA Loom azure-sql-database 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 Azure SQL database from the catalog.
  4. The editor opens at /items/azure-sql-database/<id>:

Azure SQL database editor

What this editor does

An Azure SQL database is a fully-managed PaaS database. In Loom you get a per-database T-SQL editor (TDS + AAD), geo-replication, and a native vector index — wired via ARM and TDS through the azure-sql-client. (Mirroring the database into Fabric/OneLake is opt-in only, never the default.)

Getting started

  1. Run T-SQL — Query the database over TDS with AAD auth from the editor.
  2. Build a vector index — Create a native vector column + index for similarity search over embeddings, all in T-SQL. (Mirroring the database into Fabric/OneLake is available as an opt-in, disclosed if not enabled — not the default.)
  3. Set geo-replication — PUT a geo-replication configuration for resilience.
  4. Pick a low-cost tier — Choose the serverless General Purpose tier with auto-pause, billed in vCore-seconds.

Learn more

Verified by the UAT harness