clear_table
Truncate a SQL table in a Microsoft Fabric Data Warehouse by removing all rows while preserving the table structure and schema.
Instructions
Truncate a SQL table (remove all rows, keep structure).
Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints).
The service rejects SQL Analytics Endpoints with a ToolError.
CAUTION: This is a destructive, irreversible operation. All rows will be permanently deleted. The table structure and schema are preserved. Confirm with the user before calling.
Args:
workspace: Workspace name or GUID.
item: Warehouse name or GUID. SQL Analytics Endpoints are rejected.
qualified_name: Dot-separated qualified table name, e.g. dbo.sales.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| workspace | Yes | ||
| qualified_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||