JSON as a Data Source in Query Chain

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

JSON as a Data Source in Query Chain

A Query Chain runs and executes data using different profiles. Let’s execute a Query Chain using JSON as a Data Source.

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

• Click the ‘QUERY STUDIO’ module.
• Hover on the Query Builder snippet.
• Click the Query Chain option.

• This action navigates the user to the Query Chain session page in create and edit mode.
• From the ‘Data Source’ tab, drag and drop ‘JSON’ icon.
• Double tap the ‘Read data from <JSON file>’ widget.

• A ‘Read data from JSON file’ pop-up window is displayed.

Note: By default, ‘Choose file from’ option is selected as ‘Remote.’

• Switch the ‘Choose file from’ option to ‘Local.’
• Click the plus ‘+ Choose a JSON/TXT file.’

• Browse a sample JSON file (example_2.json) and click the ‘Open’ button.

• This action loads the JSON file.
• Click the ‘Get Objects’ to load the objects from the JSON file.

• Click the ‘Preview Data & Confirm Metadata’ button.

• This action loads the ‘Preview’ pop-up window.
• The ‘Metadata’ and ‘Data’ are displayed.
• Click the ‘Select’ button.

• This action closes the ‘JSON’ widget by saving its data.
• The user navigates to the Query Chain session page.
• Click the ‘Output’ tab.

• Drag and drop an ‘RD Output’ icon onto the Query Chain session page.
• Click the ‘RD Output’ widget.

• An ‘RD Output’ pop-up window is displayed.
• Click the ‘Select’ button.

• This action closes the ‘RD Output’ widget by saving its data.
• Click the ‘Execute Now’ button.

• A monitor mode is enabled.
• The Query Chain is ‘Passed’ here.
• Click the ‘RD Output’ count (1).

• This action navigates the user to the ‘Results’ tab.