All apps/dbt Core

dbt Core

dbt

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

Runs as dbt|macOS, Linux, Windows|www.getdbt.com

Open form in Otty otty.toml

Command form

ai-draft · 6 tasks · 23 fields

Run, test and build a dbt project. Other subcommands (init, docs, seed, snapshot...) are left out.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui dbt

`dbt run`

Run models

Runs the models in the project.

Run modelsExample values, fixed in this page — nothing here reaches a terminal

Basic

Target

string

Select

string

Exclude

string

TasksEach one presets the form for one job

Run selected models

selectexcludetarget

Fail fast

selectfail_fast

ParametersOnly these flags are editable in the form

Profiles directory

path

--profiles-dir

Profile

string

--profile

Target

string

--targetdevprod

Select

Selection expression, e.g. tag:nightly or my_model+.
string

--select-s

Exclude

string

--exclude

Threads

integer

--threads

Variables

YAML string overriding dbt_project.yml variables.
string

--vars

Stop at first failure

boolean

--fail-fast-x

Full refresh incrementals

boolean

--full-refresh

`dbt test`

Run tests

Executes tests defined in the project.

Run testsExample values, fixed in this page — nothing here reaches a terminal

Basic

Select

string

Exclude

string

TasksEach one presets the form for one job

Test selected models

selectexclude

Fail fast

selectfail_fast

ParametersOnly these flags are editable in the form

Profiles directory

path

--profiles-dir

Profile

string

--profile

Select

Selection expression, e.g. tag:nightly or my_model+.
string

--select-s

Exclude

string

--exclude

Stop at first failure

boolean

--fail-fast-x

`dbt build`

Build everything

Runs models, tests, snapshots and seeds in DAG order.

Build everythingExample values, fixed in this page — nothing here reaches a terminal

Basic

Target

string

Select

string

Exclude

string

TasksEach one presets the form for one job

Build selected nodes

selectexcludetarget

Fail fast

selectfail_fast

ParametersOnly these flags are editable in the form

Profiles directory

path

--profiles-dir

Profile

string

--profile

Target

string

--targetdevprod

Select

Selection expression, e.g. tag:nightly or my_model+.
string

--select-s

Exclude

string

--exclude

Threads

integer

--threads

Variables

YAML string overriding dbt_project.yml variables.
string

--vars

Stop at first failure

boolean

--fail-fast-x

Full refresh incrementals

boolean

--full-refresh

SourcesEvery flag above is checked against these

fig

completion

fig

completion

fig

completion

fig

completion

Before it fills your prompt, Otty checks the installed dbt against its version. A form that does not match your version is not offered.