CLI Reference
sqb test
Run SQL unit tests and multi-model tests in isolation.
Runs SQL unit tests, independently reported parameterized cases, and multi-model tests without building models. Useful for validating test logic independently.
sqb --project-dir <path> test [flags]| Flag | Description |
|---|---|
--no-sql-analysis |
Disable compile-time SQL analysis (--no-sql-validation is an alias) |
--select, -s |
Select tests targeting specific models |
--exclude |
Exclude tests targeting specific models |
Parameterized cases use parent-level selection. Selecting a target model includes every case in
each matching TEST template; case names are not model selectors.
Text output identifies each case as <parent> [<case>] and includes its source path and safe typed
parameters. Structured JSON emits one check per case with stable source/block/case identity,
declared parameter types and nullability, typed values, and a content fingerprint. Exact decimals
are strings in JSON so their scale is preserved.
Examples
Section titled “Examples”# Run all testssqb test
# Run tests for a specific modelsqb test --select stg_orders