Data Export

Production - CSV, Excel, PDF, Parquet export with formatting

The Export system supports exporting query results, dashboard data, and analysis reports in multiple formats.

12.4.4.1Export Formats

Format	Extension	Use Case
CSV	`.csv`	Data interchange, spreadsheet import
Excel	`.xlsx`	Formatted spreadsheets with charts
PDF	`.pdf`	Formatted reports for printing/sharing
Parquet	`.parquet`	Efficient columnar storage for analytics
JSON	`.json`	API integration, programmatic access

# Export query results as CSV
curl -X POST http://localhost:8000/api/v1/bi/export \
  -H "Content-Type: application/json" \
  -H "X-Tenant-ID: acme-corp" \
  -d '{
    "sql": "SELECT * FROM orders WHERE order_date >= '''2024-01-01'''",
    "format": "csv",
    "filename": "orders_2024",
    "options": {"include_header": true, "delimiter": ","}
  }' \
  -o orders_2024.csv
 
# Export dashboard as PDF
curl -X POST http://localhost:8000/api/v1/bi/dashboards/{dashboard_id}/export \
  -H "X-Tenant-ID: acme-corp" \
  -d '{"format": "pdf", "include_data": true}' \
  -o dashboard_report.pdf

Alerts Query Filters