import { basalt } from "@basalt/sdk";
const db = basalt({ project: "acme-prod" });
await db.source("payments", { kafka: "payments.v3" });
await db.view("revenue_by_minute", `
SELECT window(ts, '1m') AS minute, sum(amount) AS revenue
FROM payments GROUP BY 1`);
const rows = await db.table("revenue_by_minute").last(60); from basalt import Basalt
db = Basalt(project="acme-prod")
db.source("payments", kafka="payments.v3")
db.view("revenue_by_minute", """
SELECT window(ts, '1m') AS minute, sum(amount) AS revenue
FROM payments GROUP BY 1""")
rows = db.table("revenue_by_minute").last(60) npx basalt init acme-prod
basalt source add payments --kafka payments.v3
basalt view apply ./views/revenue.sql
basalt deploy --region eu-north-1
✓ source payments connected · 1.28M ev/s
✓ view revenue_by_minute materialized in 812 ms
✓ GET /v1/revenue_by_minute ready