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

Re-usable RDBMS Custom SQL Query using MSSQL

Write and save a custom T-SQL query against an MSSQL data source.

Overview

This guide demonstrates creating a reusable Custom SQL query using MSSQL in Data Trust Query Studio. Custom SQL queries bypass the metadata layer and execute raw T-SQL directly against the MSSQL database engine.

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 MSSQL connection profile has been configured.

Steps

Path: Data Trust › Query Studio › Re-usable RDBMS Custom SQL Query using MSSQL

Figure 1: Query Option

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.

Figure 2: MSSQL Connection Selected

This step shows MSSQL Connection Selected in the Re-usable RDBMS Custom SQL Query using MSSQL workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 3: Select Table

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: Result Tab

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.

Figure 5: Save Query

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 6: Query Saved Successfully

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.