v1

latestOpenAPI 3.0.12026-07-26245126202.6 KB

Query API

Execute a SQL query

Run SQL queries on StarTree Cloud's real-time analytics engine.

post/query/sql

Headers

databasestring required

Example:ws_2kc8e2dnzzb0

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

Request body

sqlstring required

Example request

{
  "sql": "SELECT * FROM eth_raw_logs_v2 LIMIT 1"
}

Response

Query executed successfully.

Example response

{
  "resultTable": {
    "dataSchema": {
      "columnNames": [
        "id",
        "log_index",
        "transaction_hash"
      ],
      "columnDataTypes": [
        "LONG",
        "INT",
        "STRING"
      ]
    },
    "rows": [
      [
        123456,
        42,
        "0xabc123..."
      ]
    ]
  }
}