create_empty_table
Create an empty table in a Fabric Data Warehouse by defining columns with names and T-SQL types. Specify schema, table name, column definitions, and optional clustering.
Instructions
Create an empty table from an explicit column spec (DDL only, no data).
Builds CREATE TABLE [schema].[table] (col TYPE [NULL|NOT NULL], …) from
the supplied column definitions. No data is read or inserted; this is a
pure DDL operation.
Server-side file access is unreliable in MCP deployments, so CSV/Parquet
inference is not available via this tool — use the fabric-dw tables create --from-parquet or --from-csv CLI commands instead.
Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints).
When cluster_by is supplied, each column must appear in columns.
Args:
workspace: Workspace name or GUID.
item: Warehouse name or GUID.
qualified_name: Dot-separated qualified table name, e.g. dbo.sales.
columns: List of column definitions, each a dict with:
name (str) — column identifier;
sql_type (str) — Fabric-DW T-SQL type, e.g. "INT", "VARCHAR(255)";
nullable (bool, optional, default true) — whether the column allows NULL.
cluster_by: Optional list of column names for the CLUSTER BY clause
(up to 4). Each name must appear in columns.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| columns | Yes | ||
| workspace | Yes | ||
| cluster_by | No | ||
| qualified_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||