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

Auto Generate Queries

Generate multiple queries in bulk by uploading a populated mapping template.

Overview

The Auto Generate Queries feature creates multiple reusable queries in bulk by importing a populated mapping template. This dramatically reduces setup time when a large number of queries need to be created against the same connection.

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 mapping template has been populated.

Steps

Path: Data Trust › Query Studio › Auto Generate Queries

Figure 1: Auto Generated Querie option

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

Figure 2: Download Template Option

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

Figure 3: Downloaded template

This step shows Downloaded template in the Auto Generate Queries workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 4: select a file and upload

The select a file and upload 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 5: Failed due to same name

This step shows Failed due to same name in the Auto Generate Queries workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 6: Generated Query

The Generated Query step is part of the Auto Generate Queries workflow that creates multiple queries from a mapping spreadsheet. Download the template, populate it with source connection and table details, then upload it to generate queries in bulk.

Figure 7: 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 8: 6Queries Generated

This step shows 6Queries Generated in the Auto Generate Queries workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.