Cloning objects between environments with dbt clone
The dbt clone command creates lightweight clones of upstream models into your current target schema, using database-native cloning (e.g., zero-copy clone) where supported, or view-based fallback otherwise. It is primarily used to speed up CI/CD workflows and development by avoiding full rebuilds of unchanged models, cloning them from a stateful state (like the prod manifest) instead. This is closely tied to dbt's state-based selection (--state) and deferral features.
Must-know
dbt clonerequires a--stateflag pointing to a manifest.json from a previous run, typically production, to know what to clone.- It works hand-in-hand with
state:modifiedselection, allowing unchanged models to be cloned instead of rebuilt, saving compute and time in CI jobs. - On platforms that support zero-copy cloning (e.g., Snowflake, Databricks), clones are fast, storage-efficient, and use native
CREATE ... CLONEorCREATE TABLE ... LIKEmechanics; other adapters fall back to creating views pointing to the original relation. - Cloned relations are created in the current target schema/database as defined by your target, not in the original schema, enabling isolated environments like CI schemas.
dbt cloneis distinct from--defer: deferral only resolves refs to unbuilt upstream nodes at compile time without creating anything, whereas clone actually materializes a cloned relation in your target.- Common gotcha: cloning does not re-run tests or freshness checks on the cloned model, so you must still validate that the source state is trustworthy (e.g., a recent successful prod run).
A team wants to speed up CI builds by reusing production data for any model that hasn't changed, while still fully building any model that has changed. Which command accomplishes this using dbt clone?
What you have tried across dbt Analytics Engineering's objectives, not a readiness score.
Developing and optimizing dbt models
- Tracing and confirming a model's upstream raw sources
- How dbt's core materialization types differ
- Keeping models modular and avoiding repeated logic
- What each core dbt command actually does
- Shaping a model's dependency graph so it stays readable
- Setting project-wide configuration in dbt_project.yml
- Pulling in and using a dbt package
- Writing a model in Python instead of SQL
- Granting model access through the grants config
- Configuring a snapshot to track slowly changing data
- Picking the right incremental strategy for a dataset
- Dry-running a model to check its logic and schema before a real build
- Sampling a model run before a full build
- What microbatch and other advanced materializations are for
Managing dbt models governance
Debugging data modeling errors
Troubleshooting and optimizing dbt pipelines
Implementing dbt tests
Implementing and maintaining external dependencies
Coverage checked against the published exam guide on Aug 5, 2026.
These are independent practice questions, written against this certification's published exam guide. They are not the certification vendor's own questions, and not the real exam.