Snowflake — Insert each run into a Snowflake table via the SQL API — enterprise data warehouse.

What it does

[Snowflake](https://www.snowflake.com/) is the cloud data warehouse most enterprises run their analytics on. This sink writes one row per peepshow run to a Snowflake table via the [SQL API](https://docs.snowflake.com/en/developer-guide/sql-api/intro) (`POST /api/v2/statements`). Auth is a [programmatic access token (PAT)](https://docs.snowflake.com/en/user-guide/programmatic-access-tokens) sent as a Bearer header — no driver to install, no key-pair JWT, no clock skew to debug. The first write auto-creates the table with the standard peepshow schema (`run_id · title · frames · duration · transcript · thumbnail_url · strategy · tags VARIANT · created_at`); subsequent runs append. Tags are stored as `VARIANT` so they're queryable with Snowflake's native JSON functions.

When to reach for it

• Pipe peepshow runs into the same Snowflake schema your product analytics already lives in
• Build dashboards over run history with Snowsight, Tableau, Looker, or any other Snowflake-aware BI
• Hand a write-only PAT to a CI job that records every QA video into a shared analytics warehouse

Install

npm i -g peepshow

Use it

SNOWFLAKE_ACCOUNT="xy12345.us-east-1" \
SNOWFLAKE_TOKEN="$(< ~/.snowflake-pat)" \
SNOWFLAKE_DATABASE="ANALYTICS" \
peepshow ./demo.mp4 --sink snowflake

Make it automatic

Register the sink once — every run fires it afterward. Scope by --when so it only runs for matching videos.

peepshow sinks add snowflake
peepshow sinks add snowflake --when extension=mp4,mov
peepshow sinks add snowflake --when path=/Volumes/Work/

Configuration

• SNOWFLAKE_ACCOUNT Account identifier including region, e.g. `xy12345.us-east-1` or `xy12345.privatelink`. required
• SNOWFLAKE_TOKEN Programmatic access token (PAT). Generated under User → Security → Programmatic access tokens in the Snowflake console. required
• SNOWFLAKE_DATABASE Target database. Required. required
• SNOWFLAKE_SCHEMA Schema name. Default `PUBLIC`.
• SNOWFLAKE_TABLE Table name. Default `PEEPSHOW_RUNS`. Auto-created on first write.
• SNOWFLAKE_WAREHOUSE Optional compute warehouse to bill the query to.
• PEEPSHOW_FRAME_BASE_URL When set, the first frame URL is written to the `thumbnail_url` column.

# Add to ~/.zshrc, ~/.bashrc, or a project .env the agent can load
export SNOWFLAKE_ACCOUNT="..."
export SNOWFLAKE_TOKEN="..."
export SNOWFLAKE_DATABASE="..."

peepshow sinks add snowflake
peepshow sinks add snowflake --when extension=mp4,mov

Write your own

A sink is any executable that reads the --emit json payload on stdin. Shell, Node, Python, Go — the spec's in docs/PLUGINS.md. Register persistent ones with peepshow sinks add-cmd 'your-command'.