Query the warehouse

Use this when the user asks for aggregate reporting, counts, trends, or analysis requiring SQL over Graphite warehouse tables. Inspect relevant table metadata first. Executes one read-only SELECT or WITH statement scoped to the authenticated entity. Do not use for single-connection lookup, mutations, or guessed table or column names. Results are capped at 1,000 rows or 5 MiB; if truncated=true, aggregate or narrow the query and retry.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Body Params
string
required
length between 1 and 65536

One PostgreSQL SELECT or WITH statement. Use table and column names exactly as returned by warehouse metadata.

Responses

400

The SQL statement is invalid or is not read-only.

403

The authenticated user does not have the report user role for this entity.

Language
Credentials
Bearer
JWT
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json