You are viewing Query Studio - Query Builder documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Query Studio › Query Builder

How to Create a Complex Visual Query

Create multi-table, filtered Visual SQL queries using the graphical query builder.

Overview

This guide demonstrates building a complex Visual SQL query using multiple tables, join conditions, column aliases, and filter criteria — all through the graphical Visual SQL interface. Complex queries built visually can be saved and reused exactly like hand-written SQL queries.

Note: Ensure all required connection profiles are configured in the Administration module before building queries or Query Chains in this workflow.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• An RDBMS connection profile has been configured and the target tables are accessible.

Steps

Path: Data Trust › Query Studio › How to Create a Complex Visual Query

Figure 1: Querystudio_Query navigation

Navigate to the Query Studio module and select Querystudio_Query navigation to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.

Figure 2: Query_select profile

The Query_select profile configures a CSV file as the data source for the query. Select the file connection profile, browse to the file location, and map the delimiter and header settings before saving.

Figure 3: Query_Navigator

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table, then click Select to add it to the query.

Figure 4: query_dragged tables

Drag the Query_Ged Tables widget from the palette and drop it onto the Query Chain canvas. Once placed, click the widget to open its configuration popup and complete the required settings.

Figure 5: Query_table joins

The Join widget merges two data streams based on matching key columns, similar to a SQL JOIN operation. Select the join type (Inner, Left, Right, or Full) and map the key columns from both input streams.

Figure 6: Query_Joined tables_join type

The Join widget merges two data streams based on matching key columns, similar to a SQL JOIN operation. Select the join type (Inner, Left, Right, or Full) and map the key columns from both input streams.

Figure 7: Query_choose join type pop up

The Join widget merges two data streams based on matching key columns, similar to a SQL JOIN operation. Select the join type (Inner, Left, Right, or Full) and map the key columns from both input streams.

Figure 8: Query_execute now button

Click Execute Now to run the query immediately and fetch the result set. The results appear in the Results tab, and the execution status is displayed in the progress indicator.

Figure 9: Query_results

The Query_results displays the output data returned by the query or Query Chain execution. Review row counts, column values, and data quality before saving or using the output in downstream processes.

Figure 10: Save query pop up

Click Save to persist the query or configuration to the Query Explorer. A confirmation message appears once the save completes, and the query is available for reuse in Query Chains and scenarios.

Figure 11: Query success toaster

Click Save to persist the query or configuration to the Query Explorer. A confirmation message appears once the save completes, and the query is available for reuse in Query Chains and scenarios.