Query and Explore with the Workbench
- how-to
The workbench for Enterprise Analytics provides a graphical user interface for query development and data exploration.
You use the workbench to manage your databases, scopes, and collections; create, run, and save SQL++ for Enterprise Analytics queries; and view and save query results and metrics — all in a single window.
Prerequisites
To use the Enterprise Analytics UI, you need the Enterprise Analytics Access role along with specific privileges.
Workbench Features
Features of the workbench include:
-
Controls for adding and managing databases, scopes, collections, and links. See Access and Organize Data in Enterprise Analytics.
-
A single, integrated visual interface for query development and testing. The query editor offers multi-line formatting, copy-and-paste, and syntax coloring. See Write and Run Queries.
-
Immediate display of metrics for executed queries and access to the query plan. See View Query Metrics or Plan.
-
A query history for quick revision and re-execution. See Use the Query History.
-
Define query-specific settings, including a maximum time limit and positional parameters. See Set Query Options.
-
Options for displaying query results in JSON or table format, for copying or downloading query results in JSON format. See Work with Query Results.
-
Data visualization options for query results. See Visualize Results in Charts.