Query Export
The Query Engine supports exporting query results to multiple formats for downstream consumption, reporting, and data exchange. The QueryExportController provides both synchronous and asynchronous export capabilities.
Supported Formats
| Format | Content-Type | Extension | Best For |
|---|---|---|---|
| CSV | text/csv | .csv | Spreadsheet import, ETL pipelines |
| JSON | application/json | .json | API consumers, web applications |
| JSON Lines | application/json | .jsonl | Streaming processing, log pipelines |
| Parquet | application/octet-stream | .parquet | Analytics tools, data lakes |
Export Modes
| Mode | Endpoint | Best For |
|---|---|---|
| Synchronous | POST /v1/queries/{id}/export | Small to medium result sets |
| Asynchronous | POST /v1/queries/{id}/export/async | Large result sets (>100K rows) |
Subsections
| Page | Description |
|---|---|
| CSV Export | CSV options, encoding, delimiters, quoting |
| Parquet Export | Parquet format, compression, schema mapping |
| JSON Export | JSON and JSON Lines export |
| Async Export | Large result set export with progress tracking |