You are viewing Query Studio - Query Builder documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Offload File in Query Chain

Export Query Chain output to an external file system or cloud storage location.

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.

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.
At least one connection profile and one saved query are available in the system.

Steps

Path: Data Trust › Query Studio › Offload File in Query Chain

Figure 1: image

This step shows image in the Offload File in Query Chain workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

selected columns Exceptions data

Figure 2: selected columns Exceptions data

This step shows selected columns Exceptions data in the Offload File in Query Chain workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Once you click on the save button you will land on the page below. In the below screenshot we can see the three checkboxes

Figure 3: Once you click on the save button you will land on the page below. In the below screenshot we can see the three checkboxes

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.

By selecting the First checkbox you will get offload filename with system provided name like below

Figure 4: By selecting the First checkbox you will get offload filename with system provided name like below

The By selecting the First checkbox you will get offload filename with system provided name like below 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.

By selecting the second check box it will exclude the scenario id in the file name like below screenshot in physical filename.

Figure 5: By selecting the second check box it will exclude the scenario id in the file name like below screenshot in physical filename.

The By selecting the second check box it will exclude the scenario id in the file name like below screenshot in physical filename. 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.

offload results

Figure 6: offload results

The offload results 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.

Offload results in csv

Figure 7: Offload results in csv

The Offload results in csv 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.