Skip to main content

​
sqb reconcile

Detects and repairs inconsistencies between the virtual state store and the warehouse. Virtual mode only.

​
Usage

sqb reconcile [--virtual-env <name>] [--model <name>]
sqb reconcile repair-view --virtual-env <name> --model <name>
sqb reconcile attach --virtual-env <name> --model <name> --physical-relation <relation>

​
Subcommands

​
(default)

Run a diagnostic report without changing anything: 
sqb reconcile --virtual-env dev

​
repair-view

Recreate a logical VDE view from trusted state refs: 
sqb reconcile repair-view --virtual-env dev --model fact_orders
No confirmation needed. Idempotent (CREATE OR REPLACE VIEW).

​
attach

Rebind a VDE model ref to a different tracked physical relation: 
sqb reconcile attach --virtual-env dev --model fact_orders \
  --physical-relation dev__sqb_physical.fact_orders__v_8f3a9c12
Requires confirmation by default.

​
Examples

# Diagnose issues
sqb reconcile --virtual-env dev

# Fix a missing view
sqb reconcile repair-view --virtual-env dev --model fact_orders

# Rebind a model to a different physical version
sqb reconcile attach --virtual-env dev --model fact_orders \
  --physical-relation dev__sqb_physical.fact_orders__v_71d0e4ab
See Reconcile for details on guards and when to use each subcommand.