dbt Orchestration Pipeline
v3.0 · Snowflake transformation layer · 13 models · 80 tests · 5-min cadence
Models
13
4 layers
Tests
72/80
passing
Last Run
42s
5 min ago
Freshness
✓ OK
All sources fresh
Model DAG — Execution Order
STAGING
stg_endur_trades
3,210 rows · 1.2s
stg_counterparties
48 rows · 0.4s
stg_market_prices
5,475 rows · 0.8s
stg_positions
1,820 rows · 0.6s
INTERMEDIATE
int_trades_enriched
3,210 rows · 0.9s
int_pnl_daily
365 rows · 1.1s
COMPLIANCE
emir_reportable_trades
2,890 rows · 3.4s
mifid2_transactions
3,210 rows · 2.8s
capital_requirements
1,460 rows · 4.1s
credit_exposure
48 rows · 1.5s
MART
mart_risk_daily
5,475 rows · 5.2s
mart_desk_summary
1,460 rows · 2.1s
mart_counterparty_exposure
17,520 rows · 3.8s
Model Run Details
| Model | Layer | Database | Rows | Tests | Duration | Status |
|---|---|---|---|---|---|---|
| stg_endur_trades | staging | RISKOS_STAGING | 3,210 | 8 | 1.2s | PASS |
| stg_counterparties | staging | RISKOS_STAGING | 48 | 5 | 0.4s | PASS |
| stg_market_prices | staging | RISKOS_STAGING | 5,475 | 6 | 0.8s | PASS |
| stg_positions | staging | RISKOS_STAGING | 1,820 | 4 | 0.6s | PASS |
| int_trades_enriched | intermediate | RISKOS_STAGING | 3,210 | 3 | 0.9s | PASS |
| int_pnl_daily | intermediate | RISKOS_STAGING | 365 | 2 | 1.1s | PASS |
| emir_reportable_trades | compliance | RISKOS_COMPLIANCE | 2,890 | 12 | 3.4s | PASS |
| mifid2_transactions | compliance | RISKOS_COMPLIANCE | 3,210 | 10 | 2.8s | PASS |
| capital_requirements | compliance | RISKOS_COMPLIANCE | 1,460 | 8 | 4.1s | WARN |
| credit_exposure | compliance | RISKOS_COMPLIANCE | 48 | 6 | 1.5s | PASS |
| mart_risk_daily | mart | RISKOS_MARTS | 5,475 | 7 | 5.2s | PASS |
| mart_desk_summary | mart | RISKOS_MARTS | 1,460 | 5 | 2.1s | PASS |
| mart_counterparty_exposure | mart | RISKOS_MARTS | 17,520 | 4 | 3.8s | PASS |