Data Explorer

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.

How It Works

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

---

Previewing Data

1. Open any SQL file in the editor

2. Click the Data Explorer icon in the command panel

3. Optional: Change the query row limit to your desired value (anywhere between 1-1000)

4. Click "Preview Data" to see your model's results

5. Review the compiled SQL and data output

6. 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"

---

Previewing Compiled SQL

1. Click the Data Explorer icon in the command panel

2. Click "Compiled SQL" to see your model's results

3. Review the compiled SQL to understand how your SQL, jinja, and macros unfold

---

Preview Specific SQL Segments

To preview only a portion of your model (like a CTE or subquery):

1. Highlight the desired SQL segment in your file

2. Click the Data Explorer icon in the command panel

3. Click "Preview Data" to see results for just that segment

This is useful for testing individual CTEs or subqueries before running your entire model.

---

Related Resources

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.