dbt - Documentation

The dbt IDE

Prerequisites

To set up your account to use the IDE, consult the guide on using the dbt IDE.

The dbt Integrated Development Environment (IDE) provides a realtime editing and execution environment for your dbt project. In the dbt IDE, you can write, run, test, and version control the code in your dbt project from your browser -- no command line use required.

Compiling and Running SQL

In the dbt IDE, you can compile dbt code into SQL and execute it against your database directly. The IDE leverages the open-source dbt server to intelligently recompile only the parts of your project that have changed. This brings the cycle time for dbt project development down from minutes to seconds.

Executing dbt SQL in the browser

Executing dbt SQL in the browser

Running Projects

In addition to compiling and executing SQL, you can also run dbt projects in the dbt IDE. Use dbt's rich model selection syntax to run arbitrary dbt jobs directly in your browser.

The dbt IDE updates in real-time as models, tests, seeds, and operations are run. If a model or tests fails, you can dig into the logs to find and fix the issue.

Running jobs and viewing results in the dbt IDE

Running jobs and viewing results in the dbt IDE

Version Control

Leverage git directly from the dbt IDE to version control your code from your browser. You can branch, commit, push, and pull code with a couple of clicks - no command line required.

Creating a new git branch in the IDE

Creating a new git branch in the IDE

Dark mode

As Ben Franklin once said:

In matters of principle, stand like a rock; in matters of taste, swim with the current.

Now with 205% more Dark

Now with 205% more Dark

The dbt IDE


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.