Quickstart

Write SQL. BoltPipeline analyzes and certifies it with validation, lineage, and drift preventionbefore execution—then deploys executable pipelines directly in your database. Weeks → hours.

1) Write SQL

Keep SQL as the interface. Use lightweight tags to express intent; Bolt analyzes and proposes fixes.

-- models/orders_revenue.sql
-- Tag intent; Bolt analyzes and certifies pre-prod
/* @bolt: intent=metric, subject=revenue, grain=order_id */

SELECT
  o.order_id,
  o.customer_id,
  o.order_date,
  SUM(oi.quantity * oi.unit_price) AS revenue
FROM raw.orders o
JOIN raw.order_items oi ON oi.order_id = o.order_id
GROUP BY 1,2,3;

2) Validate & Certify (pre-prod)
- Schema, join, and profiling checks are enforced by default.
- Drift detection evaluates impact before deployment and continuously monitors changes over time.
- Artifacts (checks + lineage) are explainable and auditable.
3) Deploy In-DB
No external compute. The BoltPipeline Agent operates next to your warehouse; data never leaves your boundary—only operational metadata and signals.
4) Inspect Lineage & Metrics
Column-level lineage and runtime insights help you reason about changes, impact, and reliability over time.

Vision & Validation Security & Trust

1) Write SQL

2) Validate & Certify (pre-prod)

3) Deploy In-DB

4) Inspect Lineage & Metrics

Turn SQL into Production-Ready Data Pipelines — Faster and Safer