Get sample rows from a table
hana_get_sample_dataPreview table data by fetching a limited number of rows from any SAP HANA table, with configurable row count and schema support.
Instructions
Fetch the first N rows from a table using SELECT TOP. Result is shaped by the same row/column/cell caps as hana_execute_query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Number of rows (default 10, max HANA_MAX_RESULT_ROWS) | |
| table_name | Yes | Table name | |
| schema_name | No | Schema name (defaults to HANA_SCHEMA) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | Yes | ||
| rows | Yes | ||
| offset | Yes | ||
| columns | Yes | ||
| maxRows | Yes | ||
| elapsedMs | No | ||
| totalRows | No | ||
| truncated | Yes | ||
| nextOffset | No | ||
| snapshotId | No | ||
| appliedWrap | Yes | ||
| returnedRows | Yes | ||
| columnsOmitted | Yes |