count_view_rows
Return the total row count of a view in Fabric Data Warehouses or SQL Analytics Endpoints, with optional time-travel querying.
Instructions
Return the total row count of a view 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 view name, e.g. dbo.vw_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 | |||