Skip to main content

sqb check

Runs Python checks in isolation. Checks validate the output of tasks, assets, and loaders. For SQL relation validation, use sqb audit instead.

Usage

sqb --project-dir <path> check [flags]

Flags

FlagDescription
--select, -sSelect checks to run (by name, check:, tag:, or graph expansion)
--excludeExclude checks from the selection
--no-sql-validationSkip compile-time SQL syntax validation
--jsonPrint check results as JSON
--json-outputWrite check results JSON to a file path
--varsOverride project variables
Selecting a non-check node is rejected; use sqb build to run tasks and assets.

Examples

# Run all checks
sqb check

# Run one check and its required dependencies
sqb check --select +check_orders_exported

# Run checks by tag
sqb check --select tag:exports

# Print results as JSON
sqb check --json

Output

Checks report PASS, FAIL, or WARN per check. A failing error-severity check exits non-zero; warn-severity failures are reported without failing the command. Results are written to target/run/checks/python_checks.json.

Relationship to build

sqb build runs relevant Python checks by default after the tasks, assets, and loaders they depend on have run. sqb build --no-audits skips checks alongside audits. sqb check runs only checks, on demand.