Ability to visualize data using Nested JSON – RightData

You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

Ability to visualize data using Nested JSON

Prior to 2023.03 build, we don’t have the option to visualize data from Nested JSON but now we can visualize the Nested JSON data and is restricted only to the Apache Drill profile.

To learn more, let us walk through the below steps:

Click the QUERY STUDIO module.
Hover and click on the Query Builder from the left pane options and click on Query.

A new Query session page is displayed.

Select Apache Drill JDBC from the Profile dropdown list.

Note: Currently, Nested JSON visualization is added only to the Apache Drill profile.

Switch the toggle button to Visual Query and click the Navigator.

Select a Nested JSON file (here AudiFile-altered2.json) from the Navigator.

A visualization is displayed for the selected JSON file.

Checkbox the desired columns as per the requirement and click the Execute Now icon.

A Results tab is displayed showing the Query execution details.
Click the Save icon to save the required Query.