 Query Notebook

EdgeSet provides a notebook interface for running SQL queries. You can also run queries using your favorite Presto-compatible client (see  Clients).

The query box

The query box is the first thing you see when navigating to the “Notebook” menu in EdgeSet.

the query notebook loads with an empty query box ready for SQL input

Enter your SQL query into the box and run the query by clicking Run or pressing Ctrl+Enter.

Query cards

Once you’ve run a query, a query card will appear for it in the notebook above the query box. The query card will show information about the query, whether EdgeSet has returned a result already or the query is still active or waiting.

This query card is displaying the query result table

In case of a result table, you can resize the columns of the table by dragging the top right part of a column in the header. Each column can be automatically resized to fit the column’s content by double clicking the same top right part of the column header.

A column resizer displayed on hover over the table header column

You can also reload the results of a previously completed query or revise the query. Clicking the “edit” icon on a query card will load that query’s SQL into the query box (overwriting anything already in the box).

The controls on the query card allow you to move the card up and down or minimize or close it in the notebook. A drag handle is also provided at the top of the card to allow dragging the card to a desired location.

A query result bar showing the “move query up”, “move query down”, “edit”, “reload”, “minimize” and “close” icons

Drag handle on the query card

Edgeset supports exporting query results to CSV. At any point during the query’s lifetime you can click the Download CSV button at the bottom of the query card. If the query has not started yet, an export and file download will be triggered automatically once the result becomes available.

Clicking the “close” (x) icon on a running query will cancel the query.

Large query results

EdgeSet is capable of handling very large query results. It does so by streaming the results from the query engine to your web browser and rendering only the results you’ve scrolled into view. Once EdgeSet has fetched enough results to display a table, the query engine will put the query into an idle state. If you scroll to the bottom of the results table, EdgeSet will fetch and display more rows.

Query timeouts

The query engine will only keep idle queries alive for 1 minute¹ before they will be terminated. If this happens and you try to load more results, EdgeSet will ask if you want to rerun the query.

¹ The 1 minute timeout can be configured by admins on the Settings page.