preview_table
Preview a sample of records from a table, with optional column selection and filtering, to understand its structure and content.
Instructions
Preview records from a table with optional column selection and filtering.
Returns a sample of records for understanding data structure and content. For bulk data access, use the DerivaML Python API directly.
Args: table_name: Name of the table to preview (e.g., "Image", "Subject", "Dataset"). columns: List of column names to return. Default: all columns. filters: Dictionary of {column: value} equality filters. limit: Maximum records to return (default: 25, max: 100). offset: Number of records to skip.
Returns: JSON with records array, count, and table name.
Examples: preview_table("Image") -> first 25 images preview_table("Image", columns=["RID", "Filename"], limit=10) preview_table("Subject", filters={"Species": "Human"})
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| columns | No | ||
| filters | No | ||
| table_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |