Looking for the previous version? View v2024.06 documentation →
Query — SQL Query Builder
Overview
This guide walks through the Query — SQL Query Builder workflow in Data Trust Query Studio. Follow the numbered steps below to configure, execute, and review the results.
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 › Query — SQL Query Builder
Navigate to the Query Studio module and select Query Studio Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
Navigate to the Query Studio module and select Query Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
The Query Editor 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.
Select the appropriate connection profile from the dropdown to link the query to its data source. Choosing the correct profile ensures the query reads from the intended database or system.
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.
Navigate to the Query Studio module and select Compile Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
The Compile Successful option formats or validates the SQL query written in the editor. Use Compile to check for syntax errors and Pretty Print to auto-format the SQL for readability.
Navigate to the Query Studio module and select Pretty Print option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
The Pretty Print option formats or validates the SQL query written in the editor. Use Compile to check for syntax errors and Pretty Print to auto-format the SQL for readability.
Click New Query to open a blank query editor canvas ready for a fresh SQL or Visual SQL query. Each new query starts empty — select the connection, write or build the query, and save it to the explorer when complete.
The New Query 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.
Navigate to the Query Studio module and select Variable Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
The Variables panel lists all predefined system variables and user-defined variables available for use in queries. Select a variable to insert it into the query expression, making the query dynamic and reusable across executions.
The Variables panel lists all predefined system variables and user-defined variables available for use in queries. Select a variable to insert it into the query expression, making the query dynamic and reusable across executions.
The Variables panel lists all predefined system variables and user-defined variables available for use in queries. Select a variable to insert it into the query expression, making the query dynamic and reusable across executions.
The Variables panel lists all predefined system variables and user-defined variables available for use in queries. Select a variable to insert it into the query expression, making the query dynamic and reusable across executions.
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.
The Result Tab 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.
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.
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.
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.
Navigate to the Query Studio module and select Change Query name Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
Navigate to the Query Studio module and select Where Used list Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
The Where Used List Popup panel shows all Query Chains, scenarios, and other artefacts that reference the selected query. Use this to assess the impact of modifying a query before making changes that could affect dependent processes.
Navigate to the Query Studio module and select Query Studio Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
The Query Explorer panel shows all Query Chains, scenarios, and other artefacts that reference the selected query. Use this to assess the impact of modifying a query before making changes that could affect dependent processes.
The Search Query Name panel shows all Query Chains, scenarios, and other artefacts that reference the selected query. Use this to assess the impact of modifying a query before making changes that could affect dependent processes.