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 promote

Promotes model version refs from a source VDE to a target VDE. No models are rebuilt - promotion swaps pointers and refreshes logical views. Virtual mode only.

Usage

sqb promote --from <source_vde> --to <target_vde> [flags]

Flags

FlagDescription
--fromSource VDE name (required)
--toTarget VDE name (required)
--select, -sSelect specific models to promote
--excludeExclude specific models
--allow-partial-promotionAccept a working target VDE when partial promotion leaves downstream stale
--include-stale-upstreamsAdd required stale upstream refs to the promotion scope
--verbose, -vShow uncapped model sets
--varSet project variables

Examples

# Promote all models from pr_123 to dev
sqb promote --from pr_123 --to dev

# Promote specific models
sqb promote --from pr_123 --to dev --select fact_orders

# Partial promotion with working target accepted
sqb promote --from pr_123 --to dev --select fact_orders --allow-partial-promotion

# Include stale upstreams for coherent partial promotion
sqb promote --from pr_123 --to dev --select fact_orders --include-stale-upstreams
See Promotion for details on promotion behavior, source requirements, and guards.