Links

Export compiled SQL and Jinja-SQL

Want to use your SQL somewhere else? We've got you covered.
To export the full SQL (including all parent cells) for a particular cell, right-click on the cell and select the Copy as -> Copy as SQL option (or the Export SQL button in the design bar).
Exporting SQL requires a canvas analyst role.
A new panel will open showing:
  • A preview of the compiled SQL for this cell
  • An overview of all of the upstream cells that have been compiled into this export
The DAG summary and full compiled SQL are displayed by default.

SQL + Jinja

Selecting this option makes it possible to customise the number of upstream cells included in the exported SQL by selectively treating cells as dbt models. Use this option to generate code that is compatible with dbt.
Clicking on a cell in the DAG summary will convert it to a model (indicated by the dbt symbol), which means that all cells further upstream need not be included in the compiled code. Any references to models are also converted to ref() invocations.
Depending on the contents of your cells, other changes may be applied to the compiled code (especially if those cells contain more complex Jinja expressions). A summary of those changes is visible by clicking on View code changes.