Looking for the previous version? View v2024.06 documentation →
Query Studio — Explore Data Profiling
View and manage Data Profiling sessions generated by Query Chain executions.
Overview
Explore Data Profiling lists all Data Profiling sessions generated by Query Chains that included a Data Profiling output widget. From here you can navigate to any profiling session, view its results, and review the execution history of each chain.
Navigating to Explore Data Profiling
Figure 1: Navigating to Explore Data Profiling
In the left sidebar under Query Studio, click Explore Data Profiling.
Figure 2: Explore Data Profiling page
The page lists all Data Profiling sessions. Each row shows: Profiling Name (execution timestamp + chain name), DB View Name, Query Chain name, Status, Actions icons, Duration, Executed By, Executed On, and Path. A green tick in Status means the profiling completed successfully.
Creating New Assets
Figure 3: Create button
The Create dropdown is available from Explore Data Profiling, giving quick access to create new queries, auto-generated queries, or query chains.
Figure 4: New Query
Click New Query to open the Query Builder editor.
Figure 5: Query Builder editor
The Query Builder opens with Connection, Query Name, and Folder Path fields ready to build a new SQL query.
Figure 6: Auto Generated Queries
Click Auto Generated Queries to use the automatic query generation tool.
Figure 7: Auto Generated Queries page
The auto-generation page opens for creating SQL queries from schema metadata.
Figure 8: New Query Chain
Click New Query Chain to open the Query Chain canvas.
Figure 9: Query Chain canvas
The Query Chain editor opens, ready for building a new profiling pipeline.
Filtering the Profiling List
Figure 10: Opening the filter
Click the Filter (funnel) icon to open the filter popup.
Figure 11: Filter popup
The filter popup shows fields to narrow the list by profiling session name, status, date range, and user.
Figure 12: Entering filter criteria
Fill in the relevant filter fields and click Apply to filter the list.
Figure 13: Filtered results
The list updates to show only profiling sessions matching your criteria. The total count shown at the bottom reflects the filtered results.
Customising Visible Columns
Figure 14: Choose Table Fields
Click the Choose Table Fields icon to customise which columns appear in the list.
Figure 15: Column chooser popup
All columns are selected by default. Uncheck any columns you want to hide.
Figure 16: Deselecting DB View Name
Uncheck DB View Name (or any other column) to remove it from the grid.
Figure 17: Column preferences saved
Click Save to apply your column preferences. The grid updates to show only the selected columns.
Navigating to a Query Chain
Figure 18: Clicking a Query Chain name
Click the Query Chain name link in any row to navigate directly to that Query Chain's edit page.
Figure 19: Query Chain edit page
The Query Chain Edit page opens showing the full pipeline. You can review the configuration and re-run the chain if needed.
Viewing Execution Data
Figure 20: View button hover
Back in Explore Data Profiling, hover over the View icon in the Actions column to see a tooltip confirming its function.
Figure 21: Viewing execution history
Click the View icon to open the execution data for that profiling session — showing the full profiling statistics grid for that run.
Figure 22: Returning to Explore Data Profiling
Close the execution data panel to return to the Explore Data Profiling list.
Viewing Run History
Figure 23: History icon
Click the History (clock) icon in the Actions column to see the complete run history for a specific Query Chain's profiling sessions.
Figure 24: Query Chain run history
The history view displays all past Data Profiling executions for the selected Query Chain, including timestamps, statuses, and durations. Use this to track how your data's statistical profile changes over time.