Paradime IDE provide a Just in Time JIT live compiler so that you can preview your compiled SQL on the file without having to first compile you dbt™️ resources. This allows you to quickly check how for example a macro or jinja block unfolds on the fly.
Paradime automatically adds a LIMIT 100 to the query running using the Preview data panel.
Preview dbt™️ models data
To view your compiled SQL, simply click on the 🔍 on the right-panel to open the preview data view. Here you can view your compiled SQL or click on the Preview Data Button to view your dbt™️ model results.
To preview only a portion of SQL (CTEs, Subquery), simply highlight it, and click the Preview Data Button to view the results.
By default, Paradime automatically adds a LIMIT 100 to the query running using the Preview data panel. You can change this limit anywhere between 1 - 1000 by editing the text box next to "Query Limit"
To download the data returned in the preview as a .csv, click "Download CSV".
Working with scratchpad files
In the Paradime IDE you can use scratchpad files to test and run SQL queries directly in the Editor.
Simply click on the New File button on the top-right of you screen to open scratchpad file. Here you can write queries in plain SQL or also using the dbt™️ Jinja functions like ref() or source().