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. 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: 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. There is also a set of workbook-level actions at the top:

​

Worksheets

The active worksheet displays the SQL-GPT interface at the top, followed by its contained blocks in the order they are defined within the worksheet. Block types include:

• SQL Blocks
• Text Blocks
• Image Blocks
• HTML Blocks
• Map Blocks
• Graph Blocks

At the top of the worksheet are a set of applicable action buttons: 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-GPT

Each worksheet within Workbench has an interface for interacting with SQL-GPT at the top. A natural-language question can be entered into the SQL-GPT text box in order to generate an equivalent SQL query that can be run to get an answer. The result will be added as a new SQL Block at the bottom of the worksheet. Available SQL-GPT actions include:

​

SQL-GPT Configuration

The SQL-GPT Configuration page allows one or more SQL-GPT contexts to be assigned to this worksheet. Click on a SQL-GPT context on the left and then click the right arrow to assign the context to the current worksheet. Click a context on the right and click the left arrow to unassign the context from the current worksheet. Available SQL-GPT configuration actions include:

​

SQL Blocks

Each SQL Block allows one or more SQL statements to be added or modified within it. The block-specific actions are as follows: 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. 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 as a visualization, when run. Several visualization types are available:

• Bar Chart
• Line Chart
• Pie Chart
• Scatter Plot
• Big Number
• Graph
• Map

After selecting a visualization type, two actions are available:

​

Text Blocks

A Text Block can be used to document the surrounding blocks. Some formatting and other actions are available:

​

Image Blocks

An Image Block can be used to display a static or animated URL-accessible image. Available actions include:

​

Image Configuration

The Image Configuration page allows the associated image to be configured. The image needs to be specified with an accessible URL and alignment within the block. It can optionally be given a title and a scaling height & width.

​

HTML Blocks

An HTML Block can be used to display user-entered HTML. Available actions include:

​

HTML Configuration

The HTML Configuration page allows the HTML source and title to be modified. HTML tags that may pose security risks will remain in the user-entered source, but not be displayed in the HTML Block. HTML tags are not supported for the title.

​

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. Available actions include:

​

Rendering Modes

Kinetica supports two different geospatial rendering modes:

• Heatmap: A gradient of color that represents the density of features/shapes
• Raster: Discrete colorization of each feature/shape
• Class Break: A class (range) based colorization of each feature/shape
• Track: A rasterization of features/shapes containing track information
• Contour: A 3-dimensional planar graph, where each plane is bounded by isolines and contains data with the same z value

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

• Table Options - Source table & columns, along with the rendering mode
• Map-Specific Options - Options that are specific to each map type
• 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.

​

Graph Blocks

A Graph Block is a visual graph of a given graph-oriented data set. Available actions include:

​

Graph Configuration

The Graph Configuration page allows the graph source data set to be specified and modified. The most straightforward way to configure a graph is to create a graph via SQL, and then configure the graph to use the output table of the graph creation. For an example of configuring a Graph Block, see Graph Blocks.