Looking for the previous version? View v2024.06 documentation →
Query Studio — Query Explorer
Manage and organise queries, query chains, and folders in the centralised Query Explorer.
Overview
The Query Explorer is the central hub of Query Studio. It shows queries, query chains, and auto-generated queries in a grid. Columns include Name, Path, Profile Name, Created By, Created On, Modified By, and Last Modified.
Opening Query Explorer
- Click Query Studio in the left sidebar.
- The Query Explorer page opens with the asset grid.
- Click Refresh to reload the list from the server.
- Use the Search box to find folders or files by name.
Query Explorer Page
Figure 1: Query Explorer — home view
The page lists folders and assets under Root. Each row shows Name, Path, Profile Name, Created By, Created On, Modified By, and Last Modified. Count badges on folders show how many items they contain.
Layout and toolbar
Use the view controls to switch between List view and Tiles view. Tiles view shows assets as tiles instead of table rows.
Click History to open My Activity History. Use the search control in that panel to find activity records. Click History again to close the panel.
Click Bookmarks to open My Favorites. Use Refresh or the search box there to find bookmarked folders, files, or paths. Click Bookmarks again to close the panel.
When there are many assets, the grid may load in batches. A status such as Showing 91/312 appears near the filter controls. Click Load More to fetch additional rows until the counts update (for example Showing 300/312) and loading finishes.
View modes
Use the view toggles for All, Folders only, and Content only as described below.
Figure 2: Folders only view
Selecting Folders only hides individual query and query chain rows so you can focus on the folder structure.
Figure 3: Content only view
Selecting Content only hides folders and lists only query and query chain assets — useful when searching for a specific item across folders.
Creating New Assets
Figure 4: Create dropdown menu
Click the Create button at the top-right of the Explorer. A dropdown appears with options: New Query, Auto Generated Queries, New Query Chain, and New Folder.
Figure 5: Creating a New Query
Click New Query to open the Query Builder editor where you can write and save a new SQL query.
Figure 6: Query Builder editor
The Query Builder Edit page opens. Enter the Connection name, Query Name, and Folder Path. Write your SQL in the editor and click Save. The query version shows Executable when the SQL is valid.
Figure 7: Auto Generated Queries
Click Auto Generated Queries to access the auto-query generator, which can create SQL queries from metadata and schema information automatically.
Figure 8: Auto Generated Queries page
The Auto Generated Queries page provides tools to automatically generate SQL queries based on your connected data sources and schemas — useful for quickly creating standard SELECT, COUNT, or comparison queries.
Figure 9: Creating a New Query Chain
Click New Query Chain to open the Query Chain canvas editor where you can build multi-step data processing pipelines.
Figure 10: Query Chain editor
The Query Chain canvas opens ready for you to drag and connect widgets. The subtitle confirms: 'Query Chain allows chaining of multiple queries and transformations into a sequence for advanced data processing workflows.'
Filtering the Explorer
Figure 11: Opening the Filter panel
Click the Filter icon (funnel) in the toolbar to open the filter panel. Filtering helps you narrow down the Explorer list when you have many folders and assets.
Figure 12: Filter popup
The filter popup includes fields such as Created On, Created By, Profile, and Type.
Figure 13: Entering filter criteria
Fill in the required fields and click Filter (or Apply). The grid updates to show matching assets; a summary such as Filtered Results with a count may appear.
Creating a New Folder
Figure 14: Selecting New Folder
Click Create › New Folder to organise your queries into logical groups.
Figure 15: New Folder popup
The New Folder popup shows the parent location, a Name field, and Modules so the folder can appear in the right explorers (for example Scenario Explorer, Query Explorer, and Job Explorer). Click Create to save.
Figure 16: New folder created successfully
The new folder appears in the Explorer list immediately. It can now be used to organise queries, query chains, and other assets.
Renaming, Copying, and Moving Assets
Figure 17: Row action buttons — Rename, Copy, Move
Selecting an asset row in the Explorer reveals action buttons in the toolbar. The three key folder/asset operations are Rename (pencil), Copy (copy icon), and Move (move icon).
Figure 18: Rename popup
Click Rename to open the Rename popup. Enter the new name for the folder or asset and click Save.
Figure 19: Copying an asset
Click the Copy icon to copy the selected folder or asset to the clipboard. The paste icon will appear in the toolbar.
Figure 20: Paste icon appears
After copying, the Paste icon becomes active in the toolbar. Navigate to the target folder where you want to paste the asset.
Figure 21: Pasting the copied asset
Navigate to the destination folder and click the Paste icon to create a copy of the asset there. The copied item appears with the prefix _Copy_Of_ to distinguish it from the original.
Figure 22: Moving an asset
Click the Move icon to open the Move popup.
Figure 23: Move popup
The Choose Folder dialog shows a folder tree. Use the + control to add a folder under Root, Refresh to reload the tree, and Search folder to find a destination.
Figure 24: Selecting the destination folder
Browse the folder tree, select the destination folder, and click Move to transfer the asset.
Figure 25: Asset moved successfully
A success confirmation appears and the asset disappears from its original location, now residing in the target folder.
Figure 26: Query names shown in Explorer
After organising your assets, the Explorer shows folders with their query content listed beneath them, helping you navigate the workspace efficiently.
Figure 27: Searching for a folder or asset
Use the Search bar to find a folder or asset by name, open that folder, and confirm the item you moved or copied appears in the expected location.