Skip to content

Explore

Explore lets you query your data using kdb+/q or sql. The dropdown shows the available assemblies. Once an assembly has been selected, a query can be saved to a variable using the "Get Data" form. Freeform queries can be run against these and output will be shown in the console, table or chart below.

Screenshot

The central divider is a drag bar which can be resized to better view the query or outputted results.

Set up

  1. Create an assembly and deploy it. Check the data sidebar to see the current status of the assembly.

    Newly Created Assemblies

    After a new assembly has reached the "ready" state, the page must be refreshed for this assembly to show in the assembly dropdown.

  2. Select the assembly in the assembly dropdown. From here a dataset can be saved to a variable. This can be done through the form, a kdb+/q query or an sql query. Below is an example of setting the same data to a variable using the three different methods.

    Screenshot

    Using the form

    When using the form a date range must be selected.

    Screenshot

    Screenshot

    Using a kdb+/q query

    When using a kdb+/q query a database mount must be selected e.g. rdb, hdb or idb.

  3. In the Scratchpad editor you can query the newly created variable using either kdb+/q or python.

  4. The whole scratchpad can be evaluated by pressing Run Scratchpad. The current line or selection can be run with the keyboard shortcut of CTRL + Enter, or ⌘Enter on Mac.

  5. View the data in the Console or as a Table or Visual.

Scratchpad Limitations

Currently, the scratchpad is shared amongst all users and it limited to 500MB of memory. If this limit is reached the scratchpad process will be shut down and restarted. To avoid these issues queries should be limited in the amount of data being called. For example using select[10000] from myTable over myTable if the table is large.

Options

Run Scratchpad

Executes the query. Results will be outputted in the lower Table or Visual panel.

Running Queries

When a line or selection is run, the context will by set by any preceding lines similar to \d .myContext or system "d .myContext". If there are no such lines, the global context will be used. This can be run using the keyboard shortcut of CTRL + Enter, or ⌘Enter on Mac.

Console

A console that can display the results of kdb+/q or python code executed in the scratchpad.

The console contains a context menu that can be accessed by right clicking on the console area.

Screenshot

Clear

Clear the console

Toggle Source Expressions

Toggle whether the code expression generating the result will show in the console.

Code

For example, taking this kdb+/q query:

n:20;
([] date:n?(reverse .z.d-1+til 10); instance:n?`inst1`inst2`inst3`inst4; sym:n?`USD`EUR`GBP`JPY; account:n?("aa";"bb";"cc";"dd"); cnt:n?10);

The following results will be displayed:

Screenshot

Query

Data can also be queried from a variable set in the Get Data section:

Screenshot

Table

Tabulated results from the query; results are paged.

Screenshot

First
Display results from the start of the data source (page 1).
Last
Display results from the end of the data source (last page).
Random
Select a random point in the data set to display results.
10
100
1000
10000
Filter paged results by 10, 100, 1,000, or 10,000 results per page.

Column Filter

Data columns can be sorted in ascending and descending order on a header click.

Support for data filtering with AND/OR statements available as a dropdown menu option in the header; select between contains, not contains, equals, not equal, starts with, or ends with.

Screenshot

Visual

A chart of the result data; double click on an item to edit.

Screenshot

Chart Type

Select from Bubble, Line or Bar.

Define the data source variables to chart from the x- and y-axis drop-downs. Defaults to wildcard, *, for y-axis.

Display

Click the area above the chart to open menu.

Bubble

Screenshot

Radius Data
Choose between a data source variable or Fixed sized bubbles.
Radius Scaling
Sets the scaling of bubble size.
Opacity
Define the opacity of the bubble. Range 0 (transparent) to 100 (opaque).
Scale on Zoom
When enabled, bubbles will scale on zoom; increase in size on zoom in, decrease in size on zoom out.
Enabled
Plotted bubble data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.

Line

Screenshot

Opacity
Define the opacity of the line. Range 0 (transparent) to 100 (opaque).
Fill
Fill Color
Fill Opacity
Fade to Transparent
Enable to fill the area of the line to the x-axis. Define Hex color, opacity of the fill area and optional transparency fade.
Enabled
Plotted line data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.

Bar

Screenshot

Opacity
Define the opacity of the bar. Range 0 (transparent) to 100 (opaque).
Bar Percentage
Set auto-size percentage width of bars
Bar Fixed Width
Set bar width in pixels.
Bar Width Type
Toggle between Percentage or Fixed Width for bar width.
Enabled
Plotted bar data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.

Color Palette

Screenshot

Define Hex color for each layer; plotted in order.

Animation

Screenshot

Animation Duration
Animation Easing
Define zoom animation events and length of time in milliseconds to complete. Select from swingFromTo, swingFrom, swingTo, easeFromTo, easeFrom, easeTo, easeInQuad, easeOutQuad, easeInOutQuad, easeInCubic, easeOutCubic, easeInOutCubic, easeInQuart, easeOutQuart, easeInOutQuart, easeInQuint, easeOutQuint, easeInSine, easeOutSine, easeInOutSine, easeInExpo, easeOutExpo, easeInOutExpo, easeInCirc, easeOutCirc, easeInOutCirc, easeOutBounce, easeInBack, easeOutBack, easeInOutBack, bounce, bouncePast, elastic.

Overlay

Show Crosshairs
Adds a crosshair to the chart.
Show Coordinates
Displays axis values for cursor position in chart.
Snap Crosshair to Data
Crosshair position locks to y-axis value relative to x-axis postion.
Show all data points
Crosshair displays all values in tooltip at x-axis position.
Group tooltip by layer
Group display of chart values in the tooltip by data layers.

X- and Y-Axis

Define from x- and y-axis drop-downs, the data source variables to chart. This can be selected by clicking the region in which the X- and Y-Axis are displayed.

Number of Ticks
Define number of tick labels to display in the y-axis.

Range

Use min max
Min
Max
Use minimum and maximum values of data range to define y-axis range.

Gridlines

Offset Gridlines
When enabled, sets gridlines between tick values.
Gridlines Opacity
Defines the opacity of gridlines from 0 (transparent) to 100 (opaque).

Format

Display
When enabled, displays tick values.
Begin at Zero
When enabled, plotted values will start at 0 for the y-axis.
Numeric Format
Select between Number, Smart Number and Formatted Number.
Decimal Places
Define precision of y-axis labels.
Font size
Define font-size of tick labels.
Prefix
Suffix
Add a text component before or after y-axis tick label.
Hide Trailing Zeroes
When enabled, hides trailing zeroes from axis label.
10
100
1000
10000
Filter paged results by 10, 100, 1,000, or 10,000 results per page.