query_dataset

io.github.witanmarkets/witan · Verify this server

Run one read-only SQL statement over a dataset version on the server (requires auth): DuckDB reads the version's Parquet parts as the table `records` (extra fields of an allowExtra schema are the JSON column `_extra`). Use it for counts, averages and filters instead of paging through read_dataset. Limits: versions up to 2 GiB of parts, 20 seconds, 1000 rows returned (`truncated` says if more matched). The result size counts toward your egress; a paid dataset answers with its price. A schema has no time type: times (measured_at, published_at …) are ISO 8601 text — compare them as text, or cast with measured_at::TIMESTAMP for date arithmetic.