Skip to main content
POST
/
query
/
sql
Execute a SQL query
curl --request POST \
  --url https://broker.pinot.celpxu.cp.s7e.startree.cloud/query/sql \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'database: <database>' \
  --data '
{
  "sql": "SELECT * FROM eth_raw_logs_v2 LIMIT 1"
}
'
{
  "resultTable": {
    "dataSchema": {
      "columnNames": [
        "id",
        "log_index",
        "transaction_hash"
      ],
      "columnDataTypes": [
        "LONG",
        "INT",
        "STRING"
      ]
    },
    "rows": [
      [
        123456,
        42,
        "0xabc123..."
      ]
    ]
  }
}

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Headers

​
database
string
required

Workspace ID for multi-tenant clusters (e.g., Free Tier). Not required for dedicated clusters.

Example:

"ws_2kc8e2dnzzb0"

Body

application/json
​
sql
string
required
Example:

"SELECT * FROM eth_raw_logs_v2 LIMIT 1"

Response

200 - application/json

Query executed successfully.

​
resultTable
object