Data Explorer
Last updated
Was this helpful?
Last updated
Was this helpful?
Paradime IDE's Data Explorer provides real-time data preview capabilities for your dbt™ models and SQL queries, allowing you to validate your transformations without running a full dbt™ compile.
Click the Data Explorer Tab in the Command Panel. Here you can:
Preview Data (View model results)
Download results as CSV
Preview compiled SQL
Preview specific SQL segments
Open any SQL file in the editor
Click the Data Explorer icon in the command panel
Optional: Change the query row limit to your desired value (anywhere between 1-1000)
Click "Preview Data" to see your model's results
Review the compiled SQL and data output
Optional: Download the data returned in the preview as a .csv, click "Download CSV"
By default, Paradime automatically adds a LIMIT 100
to the data preview. You can change this limit anywhere between 1 - 1000 by editing the text box next to "Query Limit"
Click the Data Explorer icon in the command panel
Click "Compiled SQL" to see your model's results
Review the compiled SQL to understand how your SQL, jinja, and macros unfold
To preview only a portion of your model (like a CTE or subquery):
Highlight the desired SQL segment in your file
Click the Data Explorer icon in the command panel
Click "Preview Data" to see results for just that segment
This is useful for testing individual CTEs or subqueries before running your entire model.
Scratchpad - Need a space for SQL experiments? Scratchpad provides a temporary environment for testing SQL and dbt™ queries without affecting your project files. Learn more about writing and testing queries in a dedicated, persistent workspace.