Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.

Skip to main content

SQLBuild home page

Getting Started

Introduction
Quickstart
Feature Comparison

dbt Compatibility

Using SQLBuild with dbt
Selection
Change-aware builds
Column lineage
Testing
Scenarios
Diff
Clone
Adding SQLBuild models

Concepts

Project Configuration
Sources
Seeds
Models
Interpolation
Python Macros
Functions
Incremental Models
Reuse from production
Snapshots (SCD Type 2)
Audits
Testing
Scenarios
Selectors
Column Lineage
Data Diffs

Python Nodes

Python Nodes
Loaders
Tasks
Assets
Checks
Factories
Providers
SQL References

Virtual Environments (Alpha)

Overview
Setup
Building
Promotion
Rollback
Adopt and Detach
Clone
Diff
Reconcile
Locks
Janitor
Recovery

Integrations

Rivers
dlt
ingestr

CLI Reference

init
playground
skills
compile
plan
build
load
seed
test
scenario
audit
freshness
check
clone
diff
lineage
dag
query
debug
janitor
clean
dbt
state
promote
rollback
reconcile

sqb init
Usage

CLI Reference

init

Scaffold a new SQLBuild project.

sqb init

Creates a new SQLBuild project with a minimal directory structure and configuration files.

Usage

sqb init

No flags. Run in the directory where you want to create the project.

ingestr playground

⌘I

Powered byThis documentation is built and hosted on Mintlify, a developer documentation platform