Preview Changes

On this page

Run the full pipeline against a temporary copy of the catalog. Nothing is committed to production.

1. Run Sandbox

ondatrasql sandbox

Or for a single model:

ondatrasql sandbox staging.orders

2. Review Output

The sandbox shows row changes, schema evolution, and validation results for every model:

╠═══ Changes ══════════════════════════════════════════════════╣
║  staging.orders                                              ║
║    Rows: 100 → 142 (+42, +42.0%)                            ║
║                                                              ║
║  mart.revenue                                                ║
║    SCHEMA EVOLUTION: + Added: region (VARCHAR)               ║
║    Rows: 5 → 6 (+1, +20.0%)                                 ║

Failed models are reported without affecting production:

[OK] raw.customers (45ms)
[OK] staging.orders (95ms)
[OK] mart.revenue (54ms)
[FAIL] mart.kpis — constraint violated: total >= 0

3. Apply Changes

If the preview looks correct, run the pipeline for real:

ondatrasql run