Snapshot Management
Two scheduled snapshots of SPMS pricing data — captured in PostgreSQL (locked) and published to Snowflake. No historical restatement.
R. Okafor · System Admin
Run failed — Monthly finance snapshot · Jun 8, 2026 · 05:00 UTC
The monthly capture did not complete. IT admin & support were notified and a user-facing alert is active on the dashboard. This snapshot publishes to PostgreSQL and Snowflake and feeds finance reporting — retry as soon as possible.
Scheduled snapshots
The system's two standard captures| Snapshot | Source → Target | Cadence | Status | Last run | Next run | Retention | Actions |
|---|---|---|---|---|---|---|---|
| Daily — dashboard feed | SPMS pricing dataPostgreSQL + Snowflake | DailyOvernight | Active | TodaySuccess | Tomorrow | Latest only — prior daily captures not retained | |
| Monthly — finance reporting | SPMS pricing dataPostgreSQL + Snowflake | Monthly6th working day · 05:00 UTC | Active | Jun 8, 2026Failed | Jul 8, 2026 | Retained in Snowflake for Forecast-to-Forecast |
Each capture carries a system-generated Snapshot ID (aligns with snapshot_id in the data model). Captured data is locked — no restatement.
Cutoff announcement
Preview
Monthly finance snapshot scheduled for Jul 8, 05:00 UTC — finalize and submit projects before the cutoff.
Posts to the dashboard Announcements feed.
Snapshot run history
Executions of the two scheduled snapshots| Snapshot | Run type | Scheduled (UTC) | Actual run | Destination | Status | Triggered by | Action |
|---|---|---|---|---|---|---|---|
| Monthly finance | Monthly | Jun 8, 05:00 | Jun 8, 05:00 | PostgreSQL + Snowflake | Failed | System | |
| Daily feed | Daily | Today · overnight | Today · 02:14 | PostgreSQL + Snowflake | Success | System | Locked |
| Monthly finance | Monthly | May 8, 05:00 | May 8, 05:02 | PostgreSQL + Snowflake | Success | System | Locked |
| Daily feed | Daily | Yesterday · overnight | Yesterday · 02:11 | PostgreSQL + Snowflake | Success | System | Locked |
| Monthly finance | Monthly | Apr 8, 05:00 | Apr 8, 06:14 | PostgreSQL + Snowflake | Success | A. Reyes · manual retry | Locked |
Successful runs are locked — no re-run or restatement. The only manual action is retry-on-failure; a failed run notifies IT admin & support and raises a user alert on the dashboard.