Looking for the previous version? View v2024.06 documentation →
Query Studio — Explore Extracts
View, download, and manage the output data extracted from executed Query Chains.
Overview
Explore Extracts shows the execution history of all Query Chains that have been run with an RD Output widget. For each execution, you can view the extracted data, download it, and track the run history — making it the go-to page for reviewing what your query chains produced.
Navigating to Explore Extracts
Figure 1: Navigating to Explore Extracts
In the left sidebar under Query Studio, click Explore Extracts.
Figure 2: Explore Extracts page
The Explore Extracts page lists all Query Chain executions. Each row shows: the execution timestamp/name, Query Chain name, DB View Name (connection), Status (green tick = success), Record Count, Actions icons, Duration, Executed By, Executed On, and Path. Click any row to drill into its details.
Creating New Assets from Explore Extracts
Figure 3: Create button in Explore Extracts
The Create button in the top-right gives you quick access to create new assets without leaving Explore Extracts.
Figure 4: New Query
Click New Query to open the Query Builder and create a new SQL query.
Figure 5: Query Builder page opened
The Query Builder opens ready for you to write a new query with Connection, Query Name, and Folder Path fields.
Figure 6: Auto Generated Queries
Click Auto Generated Queries to use the query auto-generation tool.
Figure 7: Auto Generated Queries page
The Auto Generated Queries page opens for generating SQL queries automatically.
Figure 8: New Query Chain
Click New Query Chain to open the canvas editor.
Figure 9: Query Chain canvas editor opened
The Query Chain canvas editor opens, ready for building a new chain.
Viewing Extracted Data
Figure 10: Clicking a Query Chain name
Click the Query Chain name in any row to navigate to the Query Chain's edit page.
Figure 11: Query Chain edit page
The Query Chain Edit page opens showing the full pipeline canvas. You can review the chain configuration and re-execute it if needed.
Figure 12: View icon — opening extracted data
Back in Explore Extracts, click the View (eye) icon in the Actions column to open the extracted data for that execution.
Figure 13: Viewing extracted data
The extracted data opens in a tabular grid showing all columns and rows that the Query Chain produced. Column headers show the data type icon (# for numeric, A for string). Use the horizontal scrollbar to see all columns and the pagination controls at the bottom to page through large result sets.
Downloading Extracted Data
Figure 14: Create Download button
In the extracted data view, the Create Download button is available in the top toolbar.
Figure 15: Creating a download
Click Create Download to package the extracted data into a downloadable file. The file will be available to download to your computer.
Deleting an Extract
Figure 16: Delete icon
The Delete (bin) icon in the Actions column allows you to remove an extract record from Explore Extracts.
Figure 17: Deleting an extract
Click the Delete icon. Confirm the deletion in the dialog. The extract record and its stored data are removed from Explore Extracts.
Viewing Execution History
Figure 18: History icon
Click the History (clock) icon in the Actions column to see the full execution history for a particular Query Chain.
Figure 19: Execution history
The history view shows all past executions of the selected Query Chain — their timestamps, statuses, record counts, and durations. This helps you track how the data has changed across runs over time.
Filtering the Extracts List
Figure 20: Opening the filter panel
Click the Filter icon to open the filter popup and narrow down the Explore Extracts list.
Figure 21: Filter popup
The filter popup shows fields to filter by Query Chain name, status, date range, and user.
Figure 22: Entering filter criteria
Fill in the required fields and click Apply to filter the list.
Figure 23: Filtered extracts list
The Explore Extracts list updates to show only records matching your filter criteria.
Customising Visible Columns
Figure 24: Choose Table Fields icon
Click the Choose Table Fields (column chooser) icon in the toolbar to select which columns are displayed in the Explore Extracts grid.
Figure 25: Default — all columns selected
By default all columns are selected (checked). Uncheck any columns you do not need to see.
Figure 26: Deselecting a column
Uncheck the DB View Name checkbox (or any other column) to hide it from the table.
Figure 27: Column preferences saved
Click Save. The grid updates immediately, hiding the deselected column. Your column preference is remembered for future sessions.