Run SQL queries on StarTree Cloud’s real-time analytics engine.
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..."
]
]
}
}
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Workspace ID for multi-tenant clusters (e.g., Free Tier). Not required for dedicated clusters.
"ws_2kc8e2dnzzb0"
Query executed successfully.
The response is of type object
.
Was this page helpful?
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..."
]
]
}
}
Run SQL queries on StarTree Cloud’s real-time analytics engine.
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..."
]
]
}
}
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Workspace ID for multi-tenant clusters (e.g., Free Tier). Not required for dedicated clusters.
"ws_2kc8e2dnzzb0"
Query executed successfully.
The response is of type object
.
Was this page helpful?
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..."
]
]
}
}