create_empty_table
Create an empty table in a Fabric Data Warehouse by specifying column name, SQL type, and nullability. Generates a DDL CREATE TABLE statement without inserting data.
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).
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.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workspace | Yes | ||
| item | Yes | ||
| qualified_name | Yes | ||
| columns | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||