Day 1 through Day 7 ops for pilot brand #1.

1. bronze.raw_pos_events last row · 4 min ago
2. silver.sales_transactions promoted 1,847 · 0 errors
3. gold.agg_daily_metrics behind 1 day · backfill running
4. platinum.morning_briefings 1 row · formatted_text 1,184 chars

1. 01
   Verify briefing endpoint mount shipped

   curl with Bearer service token returns 200 (was 404 across 8 days of pg_cron retries).

2. 02
   Square OAuth · automatic post-callback webhook register manual today

   Post-pilot ticket. For Day 1, register webhook via Square dashboard with signature key. Confirm bronze.webhook_registrations populated.

3. 03
   Notification service end-to-end verification day 3 check

   Email path is manual Day 1 only. Confirm auto-delivery from ProactiveBriefingService on Day 3 morning.

4. 04
   Per-merchant signature keys post-pilot

   Single Render env var works for one pilot. Multi-tenant requires encrypted per-merchant keys in integration.square_oauth_tokens.

Verification probes (run from psql)

Every status above resolves to one of these SQL queries against Supabase production.

SELECT MAX(business_date) AS latest, NOW()::date - MAX(business_date) AS days_stale
FROM gold.agg_daily_metrics
WHERE organization_id = $1;

SELECT COUNT(*) FROM bronze.raw_pos_events
WHERE organization_id = $1 AND created_at > NOW() - INTERVAL '24 hours';

SELECT title, briefing_date, length(formatted_text) AS chars
FROM platinum.morning_briefings
WHERE organization_id = $1
ORDER BY briefing_date DESC LIMIT 3;

SELECT job_name, status, COUNT(*) FROM ops.outbound_http_queue
WHERE enqueued_at > NOW() - INTERVAL '24 hours'
GROUP BY 1,2 ORDER BY 1;