read_table
Read rows from a Databricks SQL table as JSON. Specify a qualified table name, row limit (1-10000), and optional point-in-time timestamp for time-travel queries.
Instructions
Return up to count rows from a table as JSON-serialisable columns + rows.
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.
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 | |||