sqb clone

Copies model relations from one target to another. Uses zero-copy cloning where the adapter supports it, falling back to physical copies with --hard-copy. No manifest.json generation or artifact management is required. Clone works directly against live targets.

Usage

sqb --project-dir <path> clone --from <target> --to <target> [flags]

Flags

Flag	Description
`--from`	Source target (required)
`--to`	Destination target (required)
`--hard-copy`	Force physical table copies instead of zero-copy cloning
`--no-sql-validation`	Skip compile-time SQL syntax validation
`--select`, `-s`	Select specific models to clone
`--exclude`	Exclude specific models from cloning

Examples

# Clone all models from prod to dev
sqb clone --from prod --to dev

# Clone only marts to dev
sqb clone --from prod --to dev --select path:models/marts

# Force physical copies
sqb clone --from prod --to dev --hard-copy

Clone policies

Targets must allow cloning in sqlbuild_project.toml. See Project Configuration for details.

check diff

Getting Started

dbt Compatibility

Concepts

Python Nodes

Virtual Environments (Alpha)

Integrations

CLI Reference

clone

sqb clone

Usage

Flags

Examples

Clone policies

​sqb clone

​Usage

​Flags

​Examples

​Clone policies

sqb clone

Usage

Flags

Examples

Clone policies