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 Reports.

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 “Allow Explore and Parameter Editing” is selected in the Query Execution Option

Please refer to this section for further details.

Sharing Overview

Uses the Memory on Your Browser if the Number of Rows is 1000 or Fewer

If the number of rows in the table or execution result targeted by Explorer is 1000 or fewer, the transformations are performed on the user's browser by default without issuing jobs to the Data Warehouse.

By checking the Disable in-memory process checkbox, you can issue jobs to the Data Warehouse to handle the data transformation, just like the scenario with more than 1000 rows.