Guides

Practical guides for common Interlace tasks.

Available Guides

SQL Models — Header configuration, dialects, materialisations, and scheduling for .sql models. Read guide

Python Models — Arrow-native Python models: streaming, cursors, and incremental patterns. Read guide

Dynamic Models — Generate many models from a Python loop, without a templating DSL. Read guide

Engines & Connections — Configure the warehouse, named engines, attached databases, and secrets. Read guide

Environments — Production and sandbox environments, promotion, drift, and cleanup. Read guide

Multi-Engine — Pin models to different engines; Interlace moves data between them automatically. Read guide

Testing — Sandboxes, plan previews, checks, and unit-testing Python models. Read guide

Backfill — Catch up or reprocess time windows with interlace run and interlace restate. Read guide

Streaming — Durable HTTP event ingestion with @stream: idempotency, drift handling, retention. Read guide

Sources — Pull from REST APIs and databases into the warehouse: the interlace.sources client (auth, pagination, retry) and incremental cursor pulls. Read guide

Quality Checks — Ten built-in check types plus Python checks; failures block promotion. Read guide

Schema Evolution — Contracts, breaking-change classification, forward-only history, stream drift. Read guide

REST API & Service — The interlace serve daemon: HTTP API, API keys, live events, and the web UI. Read guide