Pipelines & tables
14 pipelines → 31 destination tables · health recomputed on every ledger event
| Pipeline | Source → destination | Engine | Last run | Freshness / SLA | Row Δ | Drift | On-call | Health |
|---|---|---|---|---|---|---|---|---|
sapb1-erp-sync managed_configured · Cat. 4 | SAP Business One → erp.business_partners · erp.sales_orders · erp.projects · erp.lots · erp.materials | SAP Business One managed sync | succeeded Today 12:38 | 42 min / 6h | +0.3% | none | Platform Eng | healthy |
sfdc-crm-sync managed_configured · Cat. 4 | Salesforce CRM → crm.accounts · crm.opportunities · crm.projects_revrec | Salesforce managed sync | succeeded Today 12:10 | 1h 10m / 6h | — | none | Platform Eng | healthy |
lims-results-curate native_declarative · Cat. 3 | LabVantage LIMS → lims.samples · lims.results · lims.specs | Snowflake Dynamic Table | succeeded Today 12:35 | 45 min / 2h | — | none | Platform Eng | degraded |
bmram-equipment-sync managed_configured · Cat. 4 | BMRAM → assets.equipment · assets.work_orders | Cloud Run | failed ×3 Today 12:40 | 9h 12m / 4h | — | none | Platform Eng | failing |
trackwise-qms-sync managed_configured · Cat. 4 | TrackWise → quality.deviation_events · quality.capa · quality.investigations | TrackWise managed sync | succeeded Today 12:25 | 55 min / 4h | — | none | Platform Eng | healthy |
twdms-docs-index managed_configured · Cat. 4 | TrackWise DMS → docs.controlled_documents · docs.document_versions | TrackWise DMS index | succeeded Today 12:50 | 30 min / 4h | — | none | Platform Eng | healthy |
tetra-packet-harmonize native_declarative · Cat. 3 | Tetra Data Lake → qc.data_packets · qc.instrument_runs | BigQuery scheduled query | succeeded Today 12:55 | 25 min / 1h | — | +2 cols | Platform Eng | degraded |
box-release-ingest managed_configured · Cat. 4 | Box → release.batch_records · release.coa | Box managed ingest | succeeded Today 12:40 | 40 min / 4h | — | none | Platform Eng | healthy |
qc-pdf-extract custom_code · Cat. 5 | Box → qc.extracted_equipment · qc.extracted_materials | Vertex AI + Python QCEquipmentProcessor | succeeded Today 11:30 | 1h 50m / 24h | +12% | none | WiseData | healthy |
bq-to-snowflake-qc native_declarative · Cat. 3 | Box → sf.qc.extracted_equipment | Snowflake Task | succeeded Today 13:00 | 20 min / 1h | — | none | Platform Eng | healthy |
nasuni-audit-log custom_code · Cat. 5 | Nasuni file shares → audit.file_events | Python on EC2 + CloudWatch | succeeded Today 13:16 | 4 min / 15 min | — | none | Platform Eng | healthy |
ecfr-refresh managed_configured · Cat. 4 | eCFR · FDA → reg.ecfr_sections | eCFR daily refresh | succeeded Today 10:20 | 3h / 24h | — | none | Platform Eng | healthy |
fda-refresh managed_configured · Cat. 4 | eCFR · FDA → reg.fda_actions | FDA daily refresh | succeeded Today 10:20 | 3h / 24h | — | none | Platform Eng | healthy |
box-retention-audit custom_code · Cat. 5 Illustrative record | Box → audit.retention_events · audit.document_access · audit.retention_exceptions | Python retention auditor | succeeded Today 12:50 | 30 min / 4h | — | none | Platform Eng | healthy |
Row Δ: versus trailing 7-run median · Drift: versus pinned config_version · Health: worst of freshness, last run, drift and unresolved key mappings.
box-release-ingest
healthyLast success 40 min ago against a 4h SLA; no run failure recorded. Last config change: 1 pinned Yesterday 14:00.
Downstream impact (from lineage)
- lot-context-graphStale
- Batch Disposition ReadinessCannot assert calibration
- RR-2026-088Provenance flagged
- Revenue milestone — Lot 24-0117Refresh
Run history (24h)
- Schedule
- every 4h
- Last success
- 12:40 · —
- Vendor version
- —
- On-call
- Platform Eng