Explorer

Drag-and-drop and spreadsheet-like UI to easily filter, extract, aggregate, and modify data without coding.

Explorer allows you to perform common data transformations via a graphical user interface while viewing the data. Explorer can be used on the execution results of the SQL Block or Charts in notebook and report.

Key Features

• Spreadsheet-like UI and Drag-and-drop UI:

  • Sort, filter, and select values from column headers just as in a spreadsheet.

  • Select fields, apply filters, and sort data using drag-and-drop.

• Aggregation:

  • Perform simple aggregations (Group by) using drag-and-drop.

• Field Statistics:

  • Check statistical information from column headers.

• Chart Recommendation:

  • Generate recommended charts based on the type and form of the operation results.

Where Explorer is Available

Since Explorer interacts directly with the original data, it’s available only in certain contexts.

• Notebook (DocPage/GridPage)

• Report

  • When Report type is Interactive report, and Enable explorer is selected in the Options

• Signed Embed

  • When Enable explorer is selected in the Options

Please refer to this section for further details.

Sharing Overview

In-Memory Processing

• In Explorer, if the target data is within 1000 rows and no custom SQL is used, the in-memory processing processes data on the user's browser without issuing a new query.

• This processing can be disabled by checking the Disable in-memory processing checkbox.