query_table

md.mostlyright/datasets · Verify this server

A bounded, structured query over one table's current version. NO SQL: send columns, filters, order_by, aggregates and limit as JSON. Example: {"table_id": "0f2f...", "columns": ["observed_at", "air_temp_f"], "filters": [{"column": "air_temp_f", "operator": "gte", "value": 80}], "order_by": [{"column": "observed_at", "direction": "desc"}], "limit": 50}. Ceilings: 20 columns, 8 filters, 2 sort keys, 4 aggregates, 100 rows, 64 KiB of JSON. Operators: eq, neq, in, gt, gte, lt, lte, is_null, is_not_null. Requires an mr_use_ workspace key (Authorization: Bearer) or an OAuth connection, AND the dataset must be connected to that workspace — use connect_dataset first. Returns rows plus table.version_id and table.content_digest; cite those. Do not page a whole table through this — download the Parquet instead.