Write one row per OpenDunes request into a BigQuery table.
With the bigquery destination, every OpenDunes request becomes one row in a BigQuery table of yours.
| Setting | Required | Description |
|---|---|---|
projectId | Yes | The Google Cloud project |
serviceAccountKey | Yes | A service account's JSON key, as one string. The account needs to insert rows into the table |
dataset | No | The dataset. Default opendunes |
table | No | The table. Default opendunes_traces |
dataset 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 "$(jq -n --arg key "$(cat service-account.json)" '{
name: "BigQuery",
type: "bigquery",
config: { projectId: "souk-analytics", serviceAccountKey: $key }
}')"One streaming insert per request into <projectId>.<dataset>.<table>, signed with the service account. The table must exist, with the columns the ClickHouse destination lists, in lower case — trace_id, model, total_cost (DA) and the rest. A row the table refuses is retried like any failed delivery.
Back to Broadcast overview.