read_view
Retrieve rows from a view in a Fabric warehouse or SQL endpoint as JSON. Supports time-travel reads and configurable row count.
Instructions
Return up to count rows from a view as JSON-serialisable columns + rows.
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.
count: Maximum number of rows to return (1-10000, default 10).
as_of: Optional ISO-8601 UTC timestamp for a point-in-time (time-travel)
read. When supplied the query uses OPTION (FOR TIMESTAMP AS OF ...).
Omit to read the latest data.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| as_of | No | ||
| count | No | ||
| workspace | Yes | ||
| qualified_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||