QC execution using snapshot Output of a Metadata

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

Query Chain Execution using Snapshot Output of a Metadata Query

Execute a Query Chain using a snapshot of a metadata query as its input.

Overview

This guide walks through the Query Chain Execution using Snapshot Output of a Metadata Query 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 › Query Chain Execution using Snapshot Output of a Metadata Query

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: Drag and drop metadata widget from data source

Drag the Metadata Widget From Data Source 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 3: Metadata Snapshot pop-up window

The Metadata Snapshot pop-up window captures a point-in-time copy of the query result for use as a stable reference in future comparisons. Snapshots allow you to compare current data against a historical baseline without re-running the original query.

Figure 4: Click the ‘Save’ button

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 5: Click the ‘Output’ tab.

This step shows Click the ‘Output’ tab. in the Query Chain Execution using Snapshot Output of a Metadata Query workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 6: Drag and drop an ‘RD Output

Drag the An ‘Rd Output 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 7: RD Output pop up window

The RD Output widget captures the final result set from the Query Chain for use in downstream processes. Configure the output name and format, then save the widget to make the results accessible to other scenarios and reports.

Figure 8: Execute Now’ button

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 9: Execution progress

Monitor mode shows the live execution progress of the Query Chain as each widget processes data sequentially. Watch the progress indicators to confirm all stages complete successfully before reviewing the output.

Figure 10: 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.