Creating reusable Visual SQL Query

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

Creating a Reusable Visual SQL Query

Build a reusable query graphically using the Visual SQL drag-and-drop editor.

Overview

This guide walks through the Creating a Reusable Visual SQL Query workflow in Data Trust Query Studio. Follow the numbered steps below to configure, execute, and review the results.

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.
• The relevant connection profiles have been configured in the Administration module.

Steps

Path: Data Trust › Query Studio › Creating a Reusable Visual SQL Query

Figure 1: Query Builder

The Query Builder is the main workspace for building and editing queries. Use the canvas to write SQL, add data sources, connect transformations, and configure output options.

Figure 2: ‘Query’ session page

The ‘Query’ session page is the main workspace for building and editing queries. Use the canvas to write SQL, add data sources, connect transformations, and configure output options.

Figure 3: switches the SQL Query to Visual Query

The Visual SQL toggle switches the query editor from text-based SQL mode to a graphical drag-and-drop query builder. Visual SQL is ideal for users who prefer building queries without writing raw SQL, using a point-and-click table and column selector.

Figure 4: Navigator’ slide screen

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 5: action loads the visual query

The Visual SQL toggle switches the query editor from text-based SQL mode to a graphical drag-and-drop query builder. Visual SQL is ideal for users who prefer building queries without writing raw SQL, using a point-and-click table and column selector.

Figure 6: Click the ‘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 7: Click the ‘Save’ button

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 8: Additional saving options’ pop-up window

Navigate to the Query Studio module and select Additional saving options’ pop-up window to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.

Figure 9: toaster message

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.