Use when working with Fabric SQL Database — the Azure SQL Database hosted inside a Fabric workspace. Key point: this is a DIFFERENT engine from Fabric Warehouse and does NOT share its restrictions. nvarchar/datetime/money/triggers/MERGE/ALTER COLUMN/recursive CTEs/FOR XML/temporal tables/full-text search all work. Entra ID auth only (no SQL auth), token audience `database.windows.net`, tables auto-replicate to OneLake as Delta, standard .sqlproj format.
설치
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
Use when working with Fabric SQL Database — the Azure SQL Database hosted inside a Fabric workspace. Key point: this is a DIFFERENT engine from Fabric Warehouse and does NOT share its restrictions. nvarchar/datetime/money/triggers/MERGE/ALTER COLUMN/recursive CTEs/FOR XML/temporal tables/full-text search all work. Entra ID auth only (no SQL auth), token audience `database.windows.net`, tables auto-replicate to OneLake as Delta, standard .sqlproj format.
paths
["**/*.SQLDatabase/**/*.sql"]
Fabric SQL Database
Fabric SQL Database is an Azure SQL Database hosted within a Fabric workspace. It is a completely different engine from Fabric Warehouse and does NOT share the Warehouse's restrictions.
Key Differences from Fabric Warehouse
Feature
Fabric Warehouse
Fabric SQL Database
Engine
Distributed Synapse DW
Azure SQL Database
nvarchar, datetime, money
Not supported
Fully supported
Triggers
Not supported
Fully supported
MERGE
Preview only
Fully supported
ALTER COLUMN
Not supported
Fully supported
Recursive CTEs
Not supported
Fully supported
FOR XML
Not supported
Fully supported
Transaction isolation levels
Snapshot only
All levels
CREATE USER
Not supported
Fully supported
Temporal tables
Not supported
Fully supported
Full-text search
Not supported
Fully supported
Fabric-Specific Context
Authentication: Entra ID only — SQL auth is not supported in Fabric
Token audience: https://database.windows.net/.default (same as Warehouse)
OneLake replication: Tables automatically replicate to OneLake as Delta/Parquet
SQL projects: Uses standard .sqlproj format for schema-as-code
Do NOT apply Warehouse T-SQL restrictions to Fabric SQL Database code
