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 execution results of 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 like 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.

Use 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, the same as the scenario with more than 1000 rows.