Work with Query Results
- how-to
The query results pane of the workbench provides options for displaying, copying, downloading, and otherwise working with the results of a query.
Prerequisites
To use the Enterprise Analytics UI, you need the Enterprise Analytics Access role along with specific privileges.
Review JSON Formatted Results
When you execute a query, the results display in the query results pane. By default, the JSON tab displays in the query results pane, showing the results in JSON format.
You can expand and collapse objects and array values using the small arrow icons next to the line numbers.
Review Tabular Formatted Results
The Table tab presents the results in a tabular format. Enterprise Analytics converts the JSON documents to HTML tables for this display, and presents sub-objects and sub-arrays as sub-tables. This format works well for queries that return an array of objects.
Download or Copy Results
When you view query results on the JSON tab, click Export to download the results in JSON format. You can also click the copy button next to Query Results to copy the results in JSON format.
You can then use the file with the query results as needed, or paste the results into another tool such as a spreadsheet.