Show a few rows of a table
sample_rowsReturns the first rows of one table so that a column's meaning can be checked. Requires workspace, source and table. Returns JSON {table, columns, rows, personal_data}; long text is shortened, and columns that look like personal data are masked unless show_personal_data=true. Read-only. Errors: {error, kind, hint}.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"workspace": "<workspace>",
"source": "<source>",
"table": "<table>"
},
"name": "sample_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| n | No | Number of rows, 1–20. Default 10. Example: 5. | |
| table | Yes | Table to read, by name. Example: "orders". | |
| schema | No | Schema in the source. Default "dbo". | dbo |
| source | Yes | Lakehouse, warehouse or SQL database, name or id. | |
| workspace | Yes | Fabric workspace, name or id. | |
| show_personal_data | No | true includes columns named like personal data; false (default) masks or omits them. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |