Athena
Data

Legacy alias for `/gateway/fetch`

Mirrors `/gateway/fetch` for clients still calling `/gateway/data` with the same payload/response envelope. Supports `X-Athena-Client` or direct PostgreSQL URI headers (`x-pg-uri` preferred; `x-athena-jdbc-url` / `x-jdbc-url` compatibility).

POST
/gateway/data

Header Parameters

X-User-Id?string
X-Athena-Client?string

Registered Athena client name. Optional when direct PostgreSQL URI headers are provided.

x-pg-uri?string

Preferred direct PostgreSQL URI (postgres://... or jdbc:postgresql://...).

x-athena-jdbc-url?string

Compatibility direct PostgreSQL URI header.

x-jdbc-url?string

Compatibility direct PostgreSQL URI header.

X-Strip-Nulls?string
apikey?string
x-api-key?string

optional API key mirror of the apikey header

x-supabase-url?string

Required when X-Athena-Client is custom_supabase

Formaturi
x-supabase-key?string

Required when X-Athena-Client is custom_supabase

Request Body

application/json

view_name?string
table_name?string
schema_name?string

Optional schema override (defaults to public search_path behavior).

columns?array<>|
conditions*array<>
limit?integer
current_page?integer
page_size?integer
offset?integer
total_pages?integer
strip_nulls?boolean
group_by?string

Column name to group results by

time_granularity?string

Time granularity for grouping timestamp data

Value in"day" | "hour" | "minute"
aggregation_column?string

Column to aggregate (required when using aggregation_strategy)

aggregation_strategy?string

Aggregation strategy to apply (requires aggregation_column)

Value in"cumulative_sum"
aggregation_dedup?boolean

Whether to deduplicate during aggregation

sortBy?

Optional sort (camelCase). Use sort_by for snake_case.

sort_by?

Optional sort (snake_case). Same shape as sortBy.

Response Body

curl -X POST "https://athena-cluster.com/gateway/data" \  -H "Content-Type: application/json" \  -d '{    "conditions": [      {}    ]  }'
Empty
Empty
Empty

Execute SQL via driver POST

For `driver: postgresql`, connection resolution matches gateway handlers: - Send `X-Athena-Client` for a registered client pool, or - Send direct PostgreSQL URI headers (`x-pg-uri` preferred; `x-athena-jdbc-url` / `x-jdbc-url` compatibility). For PostgreSQL driver requests, Athena accepts direct URI auth bypass (no `X-Athena-Client`, no `X-Athena-Key`) when the URI includes both username and password credentials. Non-PostgreSQL drivers still require standard auth. Optional `schema_name` is supported only for the PostgreSQL driver and configures execution search_path as `schema_name, public`.

Immediately flush all pending deferred writes POST

Triggers an immediate flush of any queued deferred writes (when `deferred_writes.enabled` is true). Useful for operators to force persistence before maintenance or to clear backpressure. When deferred writes are disabled the endpoint returns a benign success with zero counts.