Looking for the previous version? View v2024.06 documentation →
Snapshot Output and Custom Reports in a Query Chain
Overview
A Query Chain (QC) is a multi-step data pipeline built on the Query Studio canvas. It connects data source widgets (RDBMS, Query, REST API, CSV, etc.) through transformation widgets (Filter, Aggregation, Join, Pivot, Unpivot, Projection) to an RD Output or file export. Query Chains can be scheduled, emailed, and reused as inputs to scenarios.
Prerequisites
- You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
- At least one connection profile and one saved query are available in the system.
Steps
Path: Data Trust › Query Studio › Snapshot Output and Custom Reports in a Query Chain
Navigate to the Query Studio module and select Querychain navigation to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
This step shows Read data from Query widget in the Snapshot Output and Custom Reports in a Query Chain workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.
This step shows QC_Read data from Query in the Snapshot Output and Custom Reports in a Query Chain workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.
The QC_Existing Query_Metadata pop up panel configures the REST API connection including the endpoint URL, authentication method, and response mapping. Verify the connection settings and test the API call before saving to ensure the query retrieves the expected JSON payload.
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.
The Filter transformation restricts the records passing through the Query Chain to only those matching the specified conditions. Define the filter expression using field dropdowns, operator selectors, and value inputs, then save the widget.
The Filter transformation restricts the records passing through the Query Chain to only those matching the specified conditions. Define the filter expression using field dropdowns, operator selectors, and value inputs, then save the widget.
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.
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.
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.
Navigate to the Query Studio module and select QC_Existing Query_Rd output_Additioanl options to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.
The Email widget sends an automated notification with the Query Chain execution results to the specified recipients. Configure the recipient addresses, subject line, and result attachment options, then save before executing.
This step shows QC_Added emial pop up in the Snapshot Output and Custom Reports in a Query Chain workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.
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.
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.
The Email widget sends an automated notification with the Query Chain execution results to the specified recipients. Configure the recipient addresses, subject line, and result attachment options, then save before executing.
This step shows Click here download link in the Snapshot Output and Custom Reports in a Query Chain workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.
The QC_results in Excel 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.