Explorer
Drag-and-drop and spreadsheet-like UI to easily filter, extract, aggregate, and modify data without coding.
Last updated
Drag-and-drop and spreadsheet-like UI to easily filter, extract, aggregate, and modify data without coding.
Last updated
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.
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.
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 OverviewIf 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.
