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

Using Variables in Queries

Use predefined and user-defined variables to create dynamic, parameterised SQL queries.

Overview

Variables in Query Studio allow you to create dynamic SQL queries that accept parameter values at execution time. Predefined system variables (such as current date) and user-defined variables can be referenced within query expressions using the Variables panel.

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.
• A query has been created and at least one user-defined variable exists in the system.

Steps

Path: Data Trust › Query Studio › Using Variables in Queries

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: Profile dropdown

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.

Figure 3: write a query

This step shows write a query in the Using Variables in Queries workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 4: click on show variables

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.

Figure 5: select current date in show variables

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.

Figure 6: test result

This step shows test result in the Using Variables in Queries workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 7: clcik on execute now

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 8: results

The 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.