Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.sqlbuild.com/llms.txt

Use this file to discover all available pages before exploring further.

​
sqb playground

Creates a self-contained waffle shop project with DuckDB. No warehouse credentials, no git clone, no external data - just a working project you can compile, build, test, and explore immediately.

​
Usage

sqb playground [path]
If path is omitted, the project is created at sqlbuild-playground in the current directory.

​
What it creates

A complete DuckDB-backed project with:
  • Staging views, fact/dimension tables, and incremental models
  • Sources with inline expression data (no external setup)
  • Seeds, SQL functions, and a custom materialization
  • Built-in and custom audits
  • SQL unit tests including chain tests
  • Python macros

​
Example

sqb playground my-project
cd my-project
sqb compile
sqb build
sqb test

​
Notes

  • The target directory must not already exist
  • DuckDB is included as a core dependency - no extra installation needed
  • The local DuckDB database file is created on the first build