Write one row per OpenDunes request into a Snowflake table.
With the snowflake destination, every OpenDunes request becomes one row in a Snowflake table of yours.
| Setting | Required | Description |
|---|---|---|
account | Yes | Your account identifier — the part before .snowflakecomputing.com |
token | Yes | A programmatic access token for a user allowed to insert into the table |
database | No | Default SNOWFLAKE_LEARNING_DB |
schema | No | Default PUBLIC |
table | No | Default OPENDUNES_TRACES |
warehouse | No | Default COMPUTE_WH |
database, schema, table and warehouse 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": "Snowflake",
"type": "snowflake",
"config": {
"account": "myorg-myaccount",
"token": "…",
"database": "ANALYTICS",
"warehouse": "LOAD_WH"
}
}'One INSERT per request through Snowflake's SQL API, into <database>.<schema>.<table>. The table must exist, with the columns the ClickHouse destination lists: the JSON columns are written as VARIANT, TAGS as an array, TOTAL_COST as a decimal in DA, and the three times as timestamps.
Back to Broadcast overview.