Snowflake

Load traces into Snowflake for BI and historical analysis

Snowflake broadcast writes typed trace columns plus flexible VARIANT metadata so teams can power dashboards, anomaly detection, and cost governance from one warehouse.

broadcast-snowflake-config.json

{
  "destination": "snowflake",
  "enabled": true,
  "account": "eac52885.us-east-1",
  "token": "pat_...",
  "database": "AI_ANALYTICS",
  "schema": "PUBLIC",
  "table": "OPENROUTER_TRACES",
  "warehouse": "COMPUTE_WH",
  "sampling_rate": 1
}

cURL

curl https://api.therouter.ai/v1/chat/completions   -H "Authorization: Bearer $THEROUTER_API_KEY"   -H "Content-Type: application/json"   -H "X-TheRouter.ai-Broadcast: true"   -d '{
    "model":"openai/gpt-4.1",
    "messages":[{"role":"user","content":"Summarize weekly usage"}],
    "trace":{"trace_name":"Snowflake Ingest Test","department":"finance"}
  }'

Create table before testing

The destination test requires an existing writable table schema. Provision table and warehouse permissions first to avoid setup failures.