Execute a SQL query against your analytics data (experimental)
Execute a SQL query against your analytics data (experimental)
Authentication
Request
A single ClickHouse SELECT (or WITH … SELECT) statement against the analytics views. Results are automatically scoped to your organization. See GET /schema for the available views and columns.
Response
Result rows; values are ordered to match columns. 64-bit integers (UInt64/Int64 — counts, sums, amounts in cents, ids) are returned as JSON strings to preserve precision; parse them client-side as needed.