dbt Cloud: A hosted application where you can develop directly from a web browser using the dbt Cloud IDE. It also natively supports developing using a command line interface, dbt Cloud CLI. Among other features, dbt Cloud provides:
- Development environment to help you build, test, run, and version control your project faster.
- Share your dbt project's documentation with your team.
- Integrates with the dbt Cloud IDE, allowing you to run development tasks and environment in the dbt Cloud UI for a seamless experience.
- The dbt Cloud CLI to develop and run dbt commands against your dbt Cloud development environment from your local command line.
- For more details, refer to Develop dbt.
dbt Core: An open source project where you can develop from the command line.
The dbt Cloud CLI and dbt Core are both command line tools that enable you to run dbt commands. The key distinction is the dbt Cloud CLI is tailored for dbt Cloud's infrastructure and integrates with all its features.
The command line is available from your computer's terminal application such as Terminal and iTerm. With the command line, you can run commands and do other work from the current working directory on your computer. Before running the dbt project from the command line, make sure you are working in your dbt project directory. Learning terminal commands such as
cd (change directory),
ls (list directory contents), and
pwd (present working directory) can help you navigate the directory structure on your system.
In dbt Cloud or dbt Core, the commands you commonly use are:
- dbt run — Runs the models you defined in your project
- dbt build — Builds and tests your selected resources such as models, seeds, snapshots, and tests
- dbt test — Executes the tests you defined for your project
For information on all dbt commands and their arguments (flags), see the dbt command reference. If you want to list all dbt commands from the command line, run
dbt --help. To list a dbt command’s specific arguments, run
dbt COMMAND_NAME --help .