T-SQL in Fabric Warehouse – What’s Supported and What’s Not | Microsoft Fabric Tutorial

T-SQL in Fabric Warehouse – What’s Supported and What’s Not

Microsoft Fabric introduces powerful T-SQL support within the Fabric Warehouse. However, there are some important differences between what you can do in a Warehouse vs a SQL Analytics Endpoint.

✅ Supported T-SQL Features in Fabric Warehouse

• CREATE, ALTER, DROP for tables, views, functions, and procedures
• Full support for INSERT, UPDATE, DELETE, and TRUNCATE
• sp_rename to rename columns
• Common Table Expressions (CTEs), including nested CTEs (Preview)
• Session-scoped #temp tables
• ADD/DROP COLUMN (nullable only)
• ADD/DROP CONSTRAINT (only with NOT ENFORCED)

❌ Not Supported T-SQL Features

• MERGE, PREDICT, TRIGGERS
• SET ROWCOUNT, SET TRANSACTION ISOLATION LEVEL
• IDENTITY columns
• FOR JSON and FOR XML in subqueries
• ALTER TABLE (only limited cases supported)
• sp_showspaceused, CREATE USER
• Recursive queries
• Materialized views
• Manual statistics (auto only)

⚠️ SQL Analytics Endpoint – Key Limitations

• Read-only access to Delta tables
• Can create views and functions referencing Delta Lake
• No INSERT, UPDATE, DELETE, or CREATE TABLE support
• Designed for analytical querying, not DML operations

✅ Use Fabric Warehouse for complete DML + DDL capabilities.
🔍 Use SQL Analytics Endpoint for querying Lakehouse Delta tables only.

🎬 Watch the Full Tutorial

Blog post written with the help of ChatGPT.