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

JSON as a Data Source in Query Chain

Use a JSON file as a data source 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.

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 › JSON as a Data Source in Query Chain

Figure 1: Query Studio-Query Chain

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

Figure 2: Drag and drop the JSON widget on the Data Source tab

Drag the The Json Widget On The Data Source Tab 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: JSON file popup using Remote file

The JSON file popup using Remote file 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 4: JSON popup using Local file

The JSON popup using Local file 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: Choose Nation file and click on open button

The Choose Nation file and click on open 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 6: JSON local file popup

The JSON local file popup 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: Click on Preview and Confirm metadata

The Preview Data button fetches a sample of records from the selected table or query result. Verify the column names and sample values before proceeding to confirm the data source is correctly configured.

Figure 8: Click the output tab

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 9: Drag and drop the RD Output widget

Drag the The Rd Output 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 10: RD Output popup

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 11: Click on 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 12: Click the RD Output count icon

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 13: Click the Results tab

The Click the Results 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.