Need to show differentiation for Auto-Generate Queries in explorers

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-Generated Query Differentiation in Explorer

Understand how auto-generated queries are visually distinguished in the Query Explorer.

Overview

This guide walks through the Auto-Generated Query Differentiation in Explorer 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 › Auto-Generated Query Differentiation in Explorer

Figure 1: Auto Generate Queries

The Auto Generate Queries 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 2: Auto generate query page

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

Figure 3: Snowflake_JDBC connection

This step shows Snowflake_JDBC connection in the Auto-Generated Query Differentiation in Explorer workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 4: downloaded sample excel template

This step shows downloaded sample excel template in the Auto-Generated Query Differentiation in Explorer workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 5: Click the file format guidelines tab

The Click the file format guidelines tab 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 6: Click the choose file button

The Click the choose file button 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 7: Select RD Auto Generate Queries

The Select RD Auto Generate Queries 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 8: Auto Gen Queries uploaded

The Auto Gen Queries uploaded 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 9: Choose Folder popup

The Choose Folder popup option creates a copy or moves the selected query or folder within the Query Explorer hierarchy. Use this to duplicate a query as a starting point for a new one, or to reorganise the folder structure.

Figure 10: Click the Generate Queries

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

Figure 11: Created two AGQ's

This step shows Created two AGQ's in the Auto-Generated Query Differentiation in Explorer workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 12: Navigate to explorer page

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

Figure 13: Icon differentiation

This view shows how auto-generated queries are visually differentiated from manually created queries in the Query Explorer. Auto-generated queries display a distinct icon or label making it easy to identify them in a mixed query library.

Figure 14: Select auto generate query

The Select auto generate 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 15: Click the Query Chain

This step shows Click the Query Chain in the Auto-Generated Query Differentiation in Explorer workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 16: New query chain page

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.

Figure 17: Drag and Drop the Queries widget

Drag the The Queries Widget widget from the palette and drop it onto the Query Chain canvas. Once placed, click the widget to open its configuration popup and complete the required settings.

Figure 18: Queries popup window

This step shows Queries popup window in the Auto-Generated Query Differentiation in Explorer workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 19: Select auto generate query

The Select auto generate 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 20: Navigate to Edit page

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

Figure 21: Save the Auto Generate 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 22: Snowfalke_Customer saved

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 23: Change to normal query

This step shows Change to normal query in the Auto-Generated Query Differentiation in Explorer workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.