Guides#

Practical guides for common Interlace tasks.

Available Guides#

Python Models - Learn how to write effective Python models using ibis for data transformations. Read guide

SQL Models - Create SQL models with automatic dependency detection. Read guide

Connections - Configure database connections for DuckDB, Postgres, and other backends. Read guide

Environments - Set up virtual environments with shared source layers across dev, staging, and production. Read guide

Multi-Backend - Run the same models on DuckDB, PostgreSQL, Snowflake, and other backends via ibis. Read guide

Testing - Write unit tests for your models with mock dependencies and assertions. Read guide

Backfill - Re-process historical data with date-range backfills via CLI, API, or the web UI. Read guide

Streaming - Ingest events with the @stream decorator via HTTP, pub/sub, and message queues. Read guide

Quality Checks - Validate model output with built-in checks for nulls, uniqueness, freshness, and more. Read guide

Schema Evolution - Control how schema changes are handled with 5 flexibility modes. Read guide

REST API & Service - Run the HTTP service with authentication, rate limiting, and interactive API docs. Read guide