flâneur

About dbt run command | dbt Developer Hub

docs.getdbt.com · 504 words · saved by 1 readers

dbt run executes compiled sql model files against the current target database. dbt connects to the target database and runs the relevant SQL required to materialize all data models using the specified materialization strategies. Models are run in the order defined by the dependency graph generated during compilation. Intelligent multi-threading is used to minimize execution time without violating dependencies. Deploying new models frequently involves destroying prior versions of these models. In these cases, dbt run minimizes the amount of time in which a model is unavailable by first building each model with a temporary name, then dropping the existing model, then renaming the model to its correct name. The drop and rename happen within a single database transaction for database adapters that support transactions. If you provide the --full-refresh flag to dbt run, dbt will treat incremental models as table models. This is useful when You can also supply the flag by its short name: dbt

The dbt run command only applies to models. It doesn't run tests, snapshots, seeds, or other resource types. To run those commands, use the appropriate dbt commands found in the dbt commands section — such as dbt test, dbt snapshot, or dbt seed. Alternatively, use dbt build with a resource type selector. You can use the dbt run command when you want to build or rebuild models in your project. How does dbt run work?​ dbt run executes compiled SQL model files against the current target database. dbt connects to the target database and runs the relevant SQL required to materialize all data…

saved by

related reading