Source sync plan
The connector runbook turns source readiness into replayable raw-record contracts before any calculation, approval, or close-lock workflow exists.
Hardening checks
5/9
4 blocked
Alert delivery
policy_gated_no_delivery
No outbound notifications without channel approval.
Production policies
Plaid/QBO gated
policy_gated_sandbox_only · policy_gated_read_only_ingestion_only
Hardening hash
ee22d1e0e999
Latest: missing
| Check | Status | Evidence hash | Blocker |
|---|---|---|---|
Deployed scheduled sync readiness checkpoint is current deployed_scheduled_sync_readiness_current | blocked | n/a | phase_7_scheduled_sync_readiness_not_current |
Deployed source failure monitoring checkpoint is current deployed_source_failure_monitoring_current | blocked | n/a | phase_7_source_failure_monitoring_not_current |
CSV fallback validation checkpoint is current csv_fallback_validation_current | blocked | n/a | phase_7_csv_fallback_validation_not_current |
Phase 7 completion checkpoint is current phase_7_completion_checkpoint_current | blocked | n/a | phase_7_completion_checkpoint_not_current |
Outbound alert delivery waits for approved channel policy outbound_alert_delivery_policy_gated | ready | 08cf067d0095 | None |
Plaid production activation waits for policy approval plaid_production_policy_gated | ready | 08cf067d0095 | None |
QBO export workflow waits for accounting policy approval qbo_export_policy_gated | ready | 08cf067d0095 | None |
Runtime regression execution waits for explicit approval runtime_regression_execution_policy_gated | ready | 08cf067d0095 | None |
External source writes remain blocked external_writes_blocked | ready | 08cf067d0095 | None |
Every connector plan is scoped to GET/query/export operations only.
Raw records dedupe by source system, object type, source ID, and payload hash.
Source sync can stage evidence, but cannot calculate payouts or lock close periods.
Object type
publisher_month_baseline
0 runs / 0 raw rows
Authority
Backtest benchmark only
Spreadsheet rows explain historical variance but do not replace event-level spend.
Write boundary
Finance Supabase only
No Drive, bank, Stripe, QuickBooks, Plaid, or payment writes.
Rho CSV rows
0
Hash 4f53cda18c2b
Plaid rows
0
Hash 4f53cda18c2b
Matched sample
0
0 unmatched Rho · 0 unmatched Plaid
Validation hash
2fb8144d6d9b
Variance 0µ · latest missing
| Check | Status | Evidence hash | Blocker |
|---|---|---|---|
Rho CSV transactions are available rho_csv_transactions_present | blocked | 4f53cda18c2b | phase_7_rho_csv_transactions_missing |
Plaid sandbox transactions are available plaid_transactions_present | blocked | 4f53cda18c2b | phase_7_plaid_transactions_missing |
Rho and Plaid transaction samples reconcile rho_plaid_match_coverage_ready | blocked | 4f53cda18c2b | phase_7_rho_plaid_match_coverage_blocked |
Matched Rho/Plaid samples have no amount variance rho_plaid_amount_variance_absent | blocked | 4f53cda18c2b | phase_7_rho_plaid_amount_variance_detected |
CSV fallback validation remains read-only csv_fallback_read_only_boundary | ready | 4f53cda18c2b | None |
Scheduled failures
2
1 skipped steps
Stale evidence
8
1 pending sources
High-severity exceptions
0
No open high/critical exceptions
Monitoring hash
2118969754e7
Latest: missing
| Check | Status | Evidence hash | Blocker |
|---|---|---|---|
Scheduled sync readiness checkpoint is current scheduled_sync_readiness_current | blocked | n/a | phase_7_scheduled_sync_readiness_not_current |
Latest scheduled sync has no failed or skipped steps latest_scheduled_sync_has_no_failures | blocked | b6db29a41925 | phase_7_scheduled_sync_has_failures |
Scheduleable sources have no stale or pending evidence scheduleable_sources_have_no_stale_evidence | blocked | 537f5d85b299 | phase_7_scheduleable_source_evidence_not_current |
No open high-severity Finance exceptions high_severity_exceptions_absent | ready | 4f53cda18c2b | None |
Failure monitoring remains read-only and audit-only failure_monitoring_read_only_boundary | ready | b6db29a41925 | None |
Scheduled sync
failed
May 4, 9:56 PM
Scheduled connectors
2/6
2 failed / 1 skipped
Fresh source evidence
0/9
8 stale / 1 pending
Checkpoint hash
bd27c572bfe2
Latest: missing
| Check | Status | Evidence hash | Blocker |
|---|---|---|---|
Latest scheduled sync succeeded latest_scheduled_sync_succeeded | blocked | e708e9b23efd | phase_7_scheduled_sync_not_succeeded |
Scheduled connector coverage is complete scheduled_connector_coverage_complete | blocked | e708e9b23efd | phase_7_scheduled_connector_coverage_missing |
Scheduled source freshness is ready scheduled_source_freshness_ready | blocked | 5f58faa85c14 | phase_7_scheduled_source_freshness_not_ready |
Deploy verification checkpoint is verified deploy_verification_checkpoint_verified | blocked | n/a | phase_7_deploy_verification_not_verified |
Scheduled sync writes remain Finance Supabase-only finance_supabase_only_write_boundary | ready | e708e9b23efd | None |
Manual connectors are excluded from unattended sync manual_connectors_excluded | ready | e708e9b23efd | None |
| Source | Status | Latest run | Rows | Validation | Evidence |
|---|---|---|---|---|---|
Google Drive folder_inventory | Stale | May 10, 4:21 AM SLA 2d | 12 raw 3 sync runs / latest row count 12 | Freshness Stale Trace Ready Idempotency Ready | 12 raw rows across folder_inventory, publisher_contract_candidate, contract_text; latest folder_inventory run completed 2026-05-10T04:21:37.55+00:00. |
Stripe billing_snapshot | Stale | May 4, 9:56 PM SLA 1d | 0 raw 1 sync runs / latest row count 50 | Freshness Stale Trace Pending Idempotency Pending | 0 raw rows across stripe_customer, stripe_invoice, stripe_charge, stripe_payment_intent, stripe_balance_transaction, stripe_credit_note, stripe_customer_balance_transaction; latest billing_snapshot run completed 2026-05-04T21:56:41.588+00:00. |
QuickBooks sandbox accounting_snapshot | Stale | May 10, 4:23 AM SLA 1d | 0 raw 1 sync runs / latest row count 0 | Freshness Stale Trace Pending Idempotency Pending | 0 raw rows across quickbooks_company_info, quickbooks_account, quickbooks_customer, quickbooks_vendor, quickbooks_deposit, quickbooks_purchase, quickbooks_bill, quickbooks_journal_entry, quickbooks_invoice, quickbooks_payment; latest accounting_snapshot run completed 2026-05-10T04:23:58.389658+00:00. |
Gravity canonical entities gravity_canonical_entities | Stale | May 10, 4:13 AM SLA 1d | 0 raw 2 sync runs / latest row count 51 | Freshness Stale Trace Pending Idempotency Pending | 0 raw rows across gravity_canonical_entities; latest gravity_canonical_entities run completed 2026-05-10T04:13:58.645+00:00. |
Gravity campaign advertisers gravity_campaign_advertiser | Stale | May 10, 4:13 AM SLA 1d | 488 raw 2 sync runs / latest row count 1417 | Freshness Stale Trace Ready Idempotency Ready | 488 raw rows across gravity_campaign_advertiser; latest gravity_campaign_advertiser run completed 2026-05-10T04:13:58.984+00:00. |
Gravity billing adjustments gravity_billing_adjustment | Stale | May 10, 4:13 AM SLA 1d | 0 raw 2 sync runs / latest row count 85 | Freshness Stale Trace Pending Idempotency Pending | 0 raw rows across gravity_billing_adjustment; latest gravity_billing_adjustment run completed 2026-05-10T04:13:58.656+00:00. |
Gravity advertiser billing gravity_advertiser_billing | Stale | May 10, 4:13 AM SLA 1d | 0 raw 2 sync runs / latest row count 154 | Freshness Stale Trace Pending Idempotency Pending | 0 raw rows across gravity_advertiser_billing; latest gravity_advertiser_billing run completed 2026-05-10T04:13:58.727+00:00. |
Redshift spend publisher_spend_daily | Stale | May 10, 4:11 AM SLA 1d | 0 raw 1 sync runs / latest row count 351 | Freshness Stale Trace Pending Idempotency Pending | 0 raw rows across publisher_spend_daily, campaign_publisher_spend_daily; latest publisher_spend_daily run completed 2026-05-10T04:11:54.03+00:00. |
Rho CSV rho_cash_transaction | Stale | May 10, 4:23 AM SLA 7d | 0 raw 1 sync runs / latest row count 0 | Freshness Stale Trace Pending Idempotency Pending | 0 raw rows across rho_cash_transaction; latest rho_cash_transaction run completed 2026-05-10T04:23:58.389658+00:00. |
XLSX publisher baseline publisher_month_baseline | Pending | Not recorded SLA 30d | 0 raw 0 sync runs / latest row count n/a | Freshness Pending Trace Pending Idempotency Pending | No publisher_month_baseline sync run has been recorded yet. |
Plaid sandbox plaid_sandbox_snapshot | Pending | Not recorded SLA 7d | 0 raw 0 sync runs / latest row count n/a | Freshness Pending Trace Pending Idempotency Pending | No plaid_sandbox_snapshot sync run has been recorded yet. |
Ready
Finance Supabase raw-record staging tables are reachable.
Recent sync runs
10
1 Rho / 0 XLSX baseline / 0 Plaid / 6 Gravity / 1 Redshift / 1 QBO / 1 Stripe / 3 Drive runs
Raw records
10
0 Rho / 0 XLSX baseline / 0 Plaid / 580 Gravity / 351 Redshift / 0 QBO / 50 Stripe / 34 Drive rows
Latest status
succeeded
May 10, 4:23 AM
This writes only Finance Supabase `source_sync_runs`, `raw_source_records`, and `finance_audit_events` rows. It does not call external sources.
Canonical entities
gravity_canonical_entities
2 runs / 102 raw rows
Campaign advertisers
gravity_campaign_advertiser
2 runs / 2809 raw rows
Credits ledger
gravity_billing_adjustment
2 runs / 170 raw rows
Advertiser billing
gravity_advertiser_billing
2 runs / 308 raw rows
Snapshot scope
Full read-only Gravity funding snapshots
No latest-100 cap on advertiser billing or billing adjustment evidence used by Phase 4 classification.
Object type
rho_cash_transaction
1 runs / 0 raw rows
Write boundary
Finance Supabase only
No bank/Plaid/Rho mutation or money movement
Object types
plaid_item, plaid_account, plaid_transaction
0 runs / 0 raw rows
Feature flag
Sandbox only
Production Plaid remains blocked until explicitly approved
Source system
redshift
Read-only Redshift Data API access
Object type
publisher_spend_daily
Daily publisher rows from event-level impressions
Write boundary
Finance Supabase only
No payouts, close locks, or source mutations
Source system
quickbooks
Sandbox OAuth read-only API access
Object types
company, accounts, customers, vendors, deposits, purchases, bills, journals, invoices, payments
Accounting evidence before reconciliation
Write boundary
Finance Supabase only
No QuickBooks posting or invoice writes
Source system
stripe
Stripe API read-only key
Object types
customers, invoices, charges, payment intents, balance transactions, credit notes, customer balance transactions
Operational billing/payment evidence, paginated until Stripe reports has_more=false
Write boundary
Finance Supabase only
No Stripe mutations or invoice writes
Source system
google_drive
Drive API read-only scope
Object types
folder_inventory, publisher_contract_candidate, contract_text
3 inventories / 20 candidates / 11 text rows
Write boundary
Finance Supabase only
No Drive/source mutations
| Order | Source | Status | Objects | Cursor strategy |
|---|---|---|---|---|
| 1 | Stripe Stripe credential presence is configured at runtime. | Ready to plan | customers, invoices, charges, payment_intents, balance_transactions, credit_notes, customer_balance_transactions | Created/updated timestamp windows plus Stripe object IDs for replay. |
| 2 | QuickBooks sandbox QuickBooks sandbox credential presence is configured at runtime. | Ready to plan | company_info, accounts, customers, vendors, deposits, purchases, bills, journals, invoices, payments | CDC/time-window reads where supported; otherwise scheduled snapshots with cursor metadata. |
| 3 | Google Drive Google Drive credential presence is configured at runtime. | Ready to plan | folder_inventory, publisher_contract_candidate, contract_text | Nightly Drive folder inventory by page token/file modified time; file ID + revision/version anchor replay. |
| 4 | Plaid sandbox Plaid sandbox credential is missing in this runtime; keep connector blocked. | Blocked | accounts, transactions, institutions | Transactions sync cursor when production is approved; sandbox remains integration proof. |
| 5 | Rho CSV Rho CSV credential presence is configured at runtime. | Ready to plan | rho_cash_transaction | Operator-provided CSV import with source filename and row number for replayable fallback. |
| 6 | Gravity prod database Gravity prod database credential presence is configured at runtime. | Ready to plan | gravity_canonical_entities, gravity_campaign_advertiser, gravity_billing_adjustment, gravity_advertiser_billing | Read-only SQL snapshots with explicit query version, source updated timestamp, and extraction timestamp. |
| 7 | Redshift Redshift credential presence is configured at runtime. | Ready to plan | publisher_spend_daily, campaign_publisher_spend_daily, ad_clicks, engine_events | Partitioned event windows by timestamp with replayable query boundaries. |
| Source | Object | Source ID | Payload hash | Last seen |
|---|---|---|---|---|
| google_drive | publisher_contract_candidate | 1VG6P7-v84xU7gsMxeAkx8y1djRZBAgzV | 2d56f995af0e | May 10, 4:21 AM |
| google_drive | publisher_contract_candidate | 17le55T6iXo7J_zxMeiqak9VyfKWCg5ig | c82ec0fc3e37 | May 10, 4:21 AM |
| google_drive | contract_text | 1r0qKCZfXsp64LpxVk1Shdi_B76V7Caq5:text:9f9cb05983e26abd89994c95b7e75eaf6d8fc0d69373a48b29e5b0ad2bb717c3 | 3521c5b274ae | May 10, 4:21 AM |
| google_drive | publisher_contract_candidate | 1EUlODT5L8Iv-xsASgGr_iwmU6wViehkL | 823e58fe46f6 | May 10, 4:21 AM |
| google_drive | contract_text | 1aB5oatDJd0YujHEuEomkvL8iehHKkpg5:text:16feb034cd6d7c380010f32ee50b9ec8c2142483ad3df4aa0109c7622b60fdf2 | 2e884f7f88ad | May 10, 4:21 AM |
| google_drive | folder_inventory | drive-query:1ceb64ea1c70c0e5141e1bbae62130159988f0a04f3cd2dd6f4c9e289c7c7708 | 1ceb64ea1c70 | May 10, 4:21 AM |
| google_drive | contract_text | 1-CqoLdG2KwwfZVAKUnFvb2q9_JWQDdda:text:e7603ff57bc39b5a7ba503264847672ef0df2441ad57587ca6bfd4c85b2253d6 | 9aa7a069b4d6 | May 10, 4:21 AM |
| google_drive | contract_text | 1EUlODT5L8Iv-xsASgGr_iwmU6wViehkL:text:298470540f15436a95359470778599c84ddd203feefe15f6f05682d44325f4b1 | 74b9ae1b8e0b | May 10, 4:21 AM |
| google_drive | contract_text | 17le55T6iXo7J_zxMeiqak9VyfKWCg5ig:text:f3a1e3c6b31a5d71ccdf8e6037852e287a0bb537898f25b1e5c0654189a968a0 | c67ea0499f20 | May 10, 4:21 AM |
| google_drive | publisher_contract_candidate | 1-CqoLdG2KwwfZVAKUnFvb2q9_JWQDdda | 03e62dcc7afe | May 10, 4:21 AM |
| Source | Evidence policy | Idempotency key |
|---|---|---|
| Stripe | Store raw payload hash, source object ID, API version, and sync run ID before downstream use. | source_system + object_type + source_id + payload_hash |
| QuickBooks sandbox | Preserve QBO entity ID, sync token, last updated timestamp, and raw accounting payload. | source_system + object_type + source_id + payload_hash |
| Google Drive | Store folder inventory hash, file ID/name/MIME/version/revision/checksums, extracted text hash, and sync run ID before human term approval. | source_system + object_type + source_id + payload_hash |
| Plaid sandbox | Store Plaid account ID, transaction ID, pending/posted state, and payload hash. | source_system + object_type + source_id + payload_hash |
| Rho CSV | Store transaction ID/reference or row hash, source file name, row number, posting/settlement date, and payload hash. | source_system + object_type + source_id + payload_hash |
| Gravity prod database | Store canonical IDs, campaign advertiser joins, query name, query version, extraction timestamp, and row hash. | source_system + object_type + source_id + payload_hash |
| Redshift | Store publisher/date and campaign/publisher/date rows from SUM(ad_impressions.price), query window, row counts, aggregate hashes, and source trace for spend verification/classification. | source_system + object_type + source_id + payload_hash |