6. Export logic as a dbt model or database view
An optional, but very useful last step.
Once you've uncovered something useful in your exploration, it's best practice to do your best to make it easier to find similar things next time.
Often this takes the form of saving a view in your database or a model in dbt so you can find you way back to a helpful table quickly next time.
In your DAG you can find the cell you want to save as a view or model. Right-click on that cell and click 'Copy Compiled SQL'.
Now you have full compiled SQL in your clipboard. From there you can:
- paste into dbt and save as a model
- paste into your SQL IDE and save as a scheduled query or a view

Last modified 2mo ago