Prerequisites
- A dbt™ project set up in the IDE.
- Basic SQL and dbt™ knowledge.
Data Explorer
The Data Explorer has a just-in-time compiler, so you can preview how a model’s SQL resolves (macros and Jinja included) without compiling the whole project, then preview the results.1
Open the Data Explorer
Select the search icon in the right panel to open the preview view. Your compiled SQL displays automatically:
- dbt™ model code
- Compiled SQL
2
Preview results
Select Preview data to run the model or query and view results. Highlight part of a query to preview only that portion, adjust the row limit (1 to 1000), or select Download CSV to export.
Scratchpad
The Scratchpad is for quick, temporary SQL or dbt™ experiments that stay out of your project and out of git.1
Create a scratchpad file
Select New file at the top right. Paradime creates it in the
paradime_scratch folder (scratch-1, scratch-2, and so on).2
Write and preview
Write SQL or dbt™ (
ref(), macros, and so on) and use the Data Explorer for instant previews. Scratchpad files persist across sessions and are gitignored automatically.The Data Explorer shows compiled SQL and returns rows on preview; scratchpad files stay in
paradime_scratch and never appear in your commits.Next steps
Data Explorer reference
Every Data Explorer option.
Scratchpad reference
How scratchpad files work.