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.

Getting Started

dbt Compatibility

Concepts

Python Nodes

Virtual Environments (Alpha)

Integrations

CLI Reference

reconcile

sqb reconcile

Usage

Subcommands

(default)

repair-view

attach

Examples

​sqb reconcile

​Usage

​Subcommands

​(default)

​repair-view

​attach

​Examples

sqb reconcile

Usage

Subcommands

(default)

repair-view

attach

Examples