dbt - Documentation

Developer IDE

Beta Functionality

The functionality documented here is available in a limited beta in dbt Cloud. To request access to the dbt Develop interface, please write into support from within the dbt Cloud application.

Don't have an account? You can get started here.

dbt Develop

The dbt Develop interface provides a realtime compilation and execution environment for your dbt SQL. From this interface, you can develop SQL code using the same macros and context functions that are available for use in your dbt models.

Compiling SQL

From the dbt Develop editor, you can compile dbt SQL into its vanilla SQL equivalent. dbt Cloud will will submit your query for compilation against a persistent server that has your dbt project loaded into memory. Because the project is already loaded in memory, the compilation time should be almost instantaneous.

Compilation is useful for developing complex macros, iterating on model code, and building on top of your existing project. In the example below, the date_spine macro from the dbt-utils package is being compiled into its literal SQL output.

Compilation of a macro from the dbt-utils package

Compilation of a macro from the dbt-utils package

Running SQL

In addition to compiling SQL, you can also run SQL from the dbt Develop interface. dbt Cloud will first compile your SQL code, then execute it using the credentials defined in your environment's Connection. Once this SQL has been executed, you can view the compiled SQL output, or the result set from the Results pane in the Develop interface.

View your query results in the dbt Develop interface

View your query results in the dbt Develop interface

Dark mode :fire+:

Now with 200% more dark

Now with 200% more dark

Developer IDE


Suggested Edits are limited on API Reference Pages

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