aowner notified

Inbox · downstream owner

Schema changes affecting you

2 active · 1 breaking · 1 deploying in 18 hours · 1 in your queue

Your impact: affects 3 dashboards you own (Q3 Finance KPIs · GL Variance · Vendor Spend) · 4 panels touched.

Column diff

6 changes

Current

Proposed

je_legacy_idvarchar
Dropped
je_amountnumeric
je_amount_centsint8
je_currvarchar(3)
je_currency_isovarchar(3)
je_periodvarchar
je_perioddate
New
je_posted_by_user_iduuid
New
je_audit_hashvarchar(64)

Q3 Finance KPIs3 panels
- GL spend by perioduses je_period · je_amount Will break
- Top vendor accrualsuses je_amount Will break
- Currency mix (last 90d)uses je_curr Will need refactor
GL Variance1 panel
- Period-over-period varianceuses je_period · je_amount Will break
Vendor Spend1 panel
- Vendor spend (FX-normalised)uses alias: amount_usd Safe (uses safe alias)

Last sync 2 min ago · Updates auto-stream

badmin queue

ccert-aware governance

Rev 1 Rev 2 Rev 4 Rev 5 Rev 6 Rev 7

SC-2412All changes

snowflake://finance / gl_journal_entries

Schema change · #SC-2412

Breaking migration on the General Ledger. Cert-aware review console — pin the SEC-suite panels you need to protect, then route through the dual- approval chain. Audit ledger streams as decisions land.

Awaiting cert review

Cert review requiredbreakingcert-affected

This change affects 3 CERTIFIED dashboards and 1 SEC-suite pipeline. Severity is breaking; dual-approval has been auto-routed (Mei-Ling C. → David O.). Pin the panels you need to protect at the current schema version before the migration window opens.

3 panels pinned to v6ETA · 2026-05-12 · 02:00 UTC5 owners notified · 2 acknowledged

Change

Proposer · diff · migration SQL

v6 → v7

MJ

Marcus J.

Data Engineering · Finance vertical · Cardinal Bank

Severity

breaking

ETA

2026-05-12

Window

02:00 UTC

Column diff · 4 changes

1 hard drop

Before	After	Kind	Notes
entry_amt numeric(18,4)	entry_amount_usd numeric(18,4)	rename	Renamed for clarity · alias retained for two release windows.
entry_dt date	— —	drop	Removed in favor of `posted_ts` which carries timezone. Hard break.
— —	posted_ts timestamptz	add	New column · always-NOT-NULL; default = COALESCE(entry_dt, now()).
fx_rate numeric(8,4)	fx_rate numeric(12,6)	type-change	Widened precision for cross-currency rounding. Backwards compatible.

Alias view holds for 2 release windows · ~14 days until forced upgrade.

Cert-aware impact

BLOCKER · every certified panel and pipeline this change touches.

3 pinned · ~$240/mo · 14d window

Default. Panels and pipelines tagged certified. This is Ahmed's blocker view.

Q3 10-Q workpapersSECdashboardSEC-suite
AFAhmed F.· ownercert by Robert C. · CDObreaking
References dropped column entry_dt across 6 panels. Hard break.
GL ReconciliationSOXdashboardSEC-suite
AFAhmed F.· ownercert by Mei-Ling C. · Compliancerefactor needed
entry_amt → entry_amount_usd alias holds for 2 windows; refactor before forced upgrade.
Vendor risk dashboardSOC 2dashboard
DODavid O.· ownercert by Aisha P. · Security councilsafe via alias
Reads entry_amt via alias view. Will continue to work for 2 release windows.
revenue-recognition-pipelineSECpipelineSEC-suite
MJMarcus J.· ownercert by Robert C. · CDOrefactor needed
Joins on entry_dt; needs to switch to posted_ts. ~3-4 hours of refactor work.

Approval & audit

Dual approval routing · audit chain ledger · approver note.

policy v3.2

Dual approval required

Awaiting Mei-Ling C. (compliance) sign-off before D.O. (steward) can finalize.

Mei-Ling C.Compliance officer · SOX/SECactive
Sign-off required because change is breaking + cert-affected.
active now
2
David O.Data platform steward
Finalizes the migration once compliance has signed off.
pending

Approval noteaudited

Visible to proposer, both approvers, and audit ledger. Markdown supported.

Audit chain ledger

9 events · streams as the change progresses

SC-2412 · v7

ledger.hash · 0x4a72…b3Verify on chain(future)

Compliance review in progress · 3 panels pinned to v6.

will log: approve · Mei-Ling C. · SC-2412 · 3 pinned · ledger 0x4a72…b3

5 owners notified · 2 acknowledged

schema change review

Schema changes affecting you

Column diff

Downstream impact· 3 dashboards / 4 panels

Schema change queue

Column diff

Downstream impact

Notify affected owners

Decision

Schema change · #SC-2412

Schema changes affecting you

Column diff

Downstream impact· 3 dashboards / 4 panels

Schema change queue

Column diff

Downstream impact

Notify affected owners

Decision

Schema change · #SC-2412