Write one row per OpenDunes request into a ClickHouse table.
With the clickhouse destination, every OpenDunes request becomes one row in a ClickHouse table of yours, ready for SQL.
| Setting | Required | Description |
|---|---|---|
host | Yes | Your ClickHouse HTTPS address, such as https://abc123.eu-west-1.aws.clickhouse.cloud:8443 |
database | Yes | The database holding the table |
username · password | Yes | A user allowed to insert into the table |
table | No | The table. Default OPENDUNES_TRACES |
database and table are plain names: letters, digits and underscores.
curl https://opendunes.com/v1/observability/destinations \
-H "Authorization: Bearer $OPENDUNES_MANAGEMENT_KEY" \
-H "Content-Type: application/json" \
-d '{
"name": "ClickHouse",
"type": "clickhouse",
"config": {
"host": "https://abc123.eu-west-1.aws.clickhouse.cloud:8443",
"database": "analytics",
"username": "opendunes_writer",
"password": "…"
}
}'One INSERT INTO <database>.<table> FORMAT JSONEachRow per request. The table must exist, with these columns:
| Columns | Hold |
|---|---|
TRACE_ID, SPAN_ID, PARENT_SPAN_ID, GENERATION_ID | the identifiers |
TIMESTAMP, START_TIME, END_TIME, DURATION_MS | the timing |
SPAN_TYPE, NAME, TRACE_NAME, LEVEL, STATUS, STATUS_MESSAGE | the span and its outcome |
MODEL, REQUESTED_MODEL, PROVIDER_NAME, FINISH_REASON | the model |
USER_ID, SESSION_ID, API_KEY_NAME | who sent it |
PROMPT_TOKENS, COMPLETION_TOKENS, TOTAL_TOKENS, TOTAL_COST | the usage; TOTAL_COST in DA |
INPUT, OUTPUT, METADATA, MODEL_PARAMETERS, ATTRIBUTES, RESOURCE_ATTRIBUTES | JSON documents |
TAGS | an array of strings |
Back to Broadcast overview.