Exploring Data with SQL

The Data Explorer is a browser-based data exploration tool that lets you write and run SQL queries against your model’s data.

The Data Explorer showing a schema sidebar, query editor, and results grid

How to Access the Data Explorer

You can open the Data Explorer from two places in the pd4castr UI:

  • From the forecast dashboard — in the options sidebar, hover over a run datetime and click the Explore Run Data icon (a folder with a magnifying glass). This opens the Data Explorer with that model run’s input and output data pre-loaded

  • From the performance metrics page — click the Explore Data link to open the Data Explorer with historical forecast output that was used to calculate the metrics pre-loaded

Writing and Running Queries

Write your SQL in the editor using standard SQL syntax.

To run a query:

  1. Write your SQL in the editor.
  2. Click the play button in the bottom-right corner of the editor. Alternatively, select a portion of text to run only that selection.
  3. Results appear in the table view below.

Viewing Results

Query results render in an interactive table view that supports several features:

  • Sorting — click column headers to sort.
  • Filtering — use the table toolbar to add filters to columns.

Available Data

The data available in the Data Explorer depends on how you accessed it:

  • Model run data — when opened from a run datetime in the forecast dashboard, the database contains input data tables and an output table for that specific run datetime. Each input corresponds to a table named after its input key.

  • Performance metrics data — when opened from the metrics page, the database contains historical forecast output that was used to calculate the metrics, with a table for each model used in the comparison.

Next Steps

To learn about monitoring model runs and debugging failures, see Author Tools.