Ability to visualize data using Nested JSON

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

Visualise Data using Nested JSON Connection

Visualise and query hierarchical nested JSON data in Data Trust.

Overview

This guide demonstrates querying Nested JSON data in Data Trust. The Nested JSON visualisation capability flattens hierarchical JSON structures into a tabular view, allowing analysis of deeply nested API or file-based JSON data sources.

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.
• A JSON connection profile or REST API profile returning nested JSON has been configured.

Steps

Path: Data Trust › Query Studio › Visualise Data using Nested JSON Connection

Figure 1: Query Explorer

The Query Explorer panel shows all Query Chains, scenarios, and other artefacts that reference the selected query. Use this to assess the impact of modifying a query before making changes that could affect dependent processes.

Figure 2: Query create page

The Query create 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: select profile and toggle to visual Query

The select profile and toggle to visual Query 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: Load table from Navigator

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table, then click Select to add it to the query.

Figure 5: Select checkboxes as per the Required columns

This step shows Select checkboxes as per the Required columns in the Visualise Data using Nested JSON Connection workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 6: 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 7: verify results

The verify 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.