count_table_rows
Return the total row count of a table in Microsoft Fabric using COUNT_BIG(*). Supports time-travel queries with an optional timestamp.
Instructions
Return the total row count of a table via SELECT COUNT_BIG(*).
Works on both Fabric Data Warehouses and SQL Analytics Endpoints.
Args:
workspace: Workspace name or GUID.
item: Warehouse or SQL endpoint name or GUID.
qualified_name: Dot-separated qualified table name, e.g. dbo.sales.
as_of: Optional ISO-8601 UTC timestamp for a point-in-time (time-travel)
count. When supplied the query uses OPTION (FOR TIMESTAMP AS OF ...).
Omit to count the latest data.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| as_of | No | ||
| workspace | Yes | ||
| qualified_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||