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.
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.
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
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
Now with 200% more dark