Explore

The Explore interface is situated in the right-hand pane of Kinetica's Workbench administration application. It can be used to import data into the database from a variety of sources.

../../images/wb.explore.fit.png

Explore Landing Page

To access the Explore page, in Workbench, click the Explore menu item. This will open the list of your workbooks in the right-hand pane, as well as a button for creating a new workbook. Additionally, at the top, are several action buttons:

  • Queries - pop up a list of the currently running queries, under the Running tab; the Perpetual tab lists active subscriptions to external data sources
  • Import - import a workbook as a JSON file
  • Export All - export all workbooks listed under My Workbooks to a single JSON file
  • Refresh icon - update the list of displayed workbook panels
  • + button - create a new workbook

Clicking on any workbook panel will open that workbook in the right-hand pane.


Workbooks

When a workbook is selected, its first worksheet is displayed, along with a corresponding tab for each of its other worksheets. Click the tabs to switch between worksheets, and click the + to create a new worksheet.

../../images/wb.explore_workbook.png

Quick Start Workbook

There is also a set of workbook-level actions at the top:

ActionDescription
ShareToggle sharing of this workbook with all other users in the warehouse
wb_icon_historyDisplay a list of the currently running queries, under the Running tab; the Perpetual tab displays a list of active subscriptions to external data sources
wb_icon_copyMake a duplicate of this workbook, appending Copy to the end of the workbook's name
wb_icon_embed

Display two means of referencing this workbook:

  • URL - a URL that can be used to link directly to this workbook, opening it in Workbench
  • HTML - an HTML snippet that can be used to embed this workbook as an iFrame within another web page; note that this will require logging into Workbench in that frame to access the embedded workbook
wb_icon_exportExport this workbook in either JSON format or as a series of SQL statements in a text file
wb_icon_refreshRefresh the displayed blocks of this workbook
wb_icon_editModify the name or description of this workbook
wb_icon_deleteDelete this workbook
wb_icon_closeClose this workbook and return to the Explore landing page

Worksheets

The active worksheet displays its contained blocks in the order they are defined within the worksheet. Block types include:

../../images/wb.explore_worksheet.png

Quick Start Worksheet #1

At the top of the worksheet are a set of applicable action buttons:

ActionDescription
ws_icon_leftMove this worksheet closer to the front of the workbook
ws_icon_rightMove this worksheet closer to the back of the workbook
ws_icon_editModify the name or description of this worksheet
ws_icon_copyMake a duplicate of this worksheet in either the current workbook or another workbook, appending Copy to the end of the workbook's name
ws_icon_sqlAdd a new SQL Block to the end of this worksheet
ws_icon_textAdd a new Text Block to the end of this worksheet
ws_icon_mapAdd a new Map Block to the end of this worksheet
ws_icon_clearClear all query results in SQL Blocks on this worksheet
ws_icon_runRun all SQL Blocks on this worksheet in the sequence in which they appear on the worksheet

To the right of the blocks is a column of numbers corresponding to each of the numbered blocks. Click any one of the numbers to jump to that block.


SQL Blocks

Each SQL Block allows one or more SQL statements to be added or modified within it.

../../images/wb.explore_wsb_sql.png

SQL Block

The block-specific actions are as follows:

ActionDescription
wsb_icon_runRun the SQL statement(s) in this SQL Block, and output the result set of the final query (if one exists) at the bottom of this block, in either data grid or chart form
wsb_icon_expandExpand or collapse this block when the enclosing workbook is embedded in another web page
wsb_icon_eyeHide or show this block when the enclosing workbook is embedded in another web page
wsb_icon_explain

Display the explain plan of the final query in this SQL Block, if one exists:

  • Explain Plan - display the basic execution plan
  • Run and Analyze - run the final query and display the execution plan with a statistical analysis
wsb_icon_runallRun all SQL Blocks from this one onwards, until the end of the worksheet
wsb_icon_addAdd a new SQL Block, Text Block, or Map Block below this one
wsb_icon_upMove this SQL Block one block above its current position on this worksheet
wsb_icon_downMove this SQL Block one block below its current position on this worksheet
wsb_icon_deleteRemove this SQL Block from this worksheet

If the SQL Block contains any queries, the result set of the final one can be displayed at the bottom of the SQL Block in either a grid view (on the Data tab) or as a chart (on the Visualization tab).

Data Tab

The Data tab displays a grid view of the result set of the final query in a SQL Block, when run.

../../images/wb.explore_wsb_sql_data.png

SQL Block Query Results Grid

Data tab actions include:

  • Export CSV - export the result set to a comma-separated values (CSV) file and download the file
  • Clear - remove the result set portion of the SQL Block

Visualization Tab

The Visualization tab allows the result set of the final query in a SQL Block to be displayed in chart form, when run.

../../images/wb.explore_wsb_sql_vis.png

SQL Block Query Results Chart

Three chart types are available:

  • Bar Chart
  • Line Chart
  • Pie Chart

After selecting a chart type, two actions are available:

  • Configure - configure the selected chart with options that are specific to the type selected; click Update to display the chart
  • X - delete the current chart and select from the available types again

Text Blocks

A Text Block can be used to document the surrounding SQL Blocks & Map Blocks.

../../images/wb.explore_wsb_text.png

Text Block

Some formatting and other actions are available:

ActionDescription
wsb_icon_boldApply bold styling to the highlighted text
wsb_icon_italApply italics styling to the highlighted text
wsb_icon_ulUnderline the highlighted text
wsb_icon_eyeHide or show this block when the enclosing workbook is embedded in another web page
wsb_icon_addAdd a new SQL Block, Text Block, or Map Block below this one
wsb_icon_upMove this Text Block one block above its current position on this worksheet
wsb_icon_downMove this Text Block one block below its current position on this worksheet
wsb_icon_deleteRemove this Text Block from this worksheet

Map Blocks

A Map Block is an empty zoomable & pannable world map, upon creation, that can be configured to display geospatial data from any table or view.

../../images/wb.explore_wsb_map.png

Map Block

Available actions include:

ActionDescription
wsb_icon_refRefresh the map, reloading any data from the source, if configured
wsb_icon_dlDownload a copy of this map at its current zoom level and pan position
wsb_icon_cfgConfigure a source table to plot on this map, as well as other map-related settings
wsb_icon_eyeHide or show this block when the enclosing workbook is embedded in another web page
wsb_icon_addAdd a new SQL Block, Text Block, or Map Block below this one
wsb_icon_upMove this Map Block one block above its current position on this worksheet
wsb_icon_downMove this Map Block one block below its current position on this worksheet
wsb_icon_deleteRemove this Map Block from this worksheet

Rendering Modes

Kinetica supports two different geospatial rendering modes:

  • Raster: Discrete colorization of each feature/shape
  • Heatmap: A gradient of color that represents the density of features/shapes

There are several categories of options to configure for each map:

  • Table Options - Source table & columns, along with the rendering mode
  • Heatmap Options - For heatmaps, the coloring & blur
  • Viewport Options - Latitude, longitude, & altitude upon which the map is centered
  • Advanced Options - WMS key/value pairs that can be set to override or extend the map configuration. See Web Map Service for details.

Here is an example of some of the map configuration options that you have to style the output of geospatial data on a map, followed by a sample map.

../../images/wb.workbook_vis_map_conf.png

Map Visualization Configuration

../../images/wb.workbook_vis_map.png

Map Visualization