Skip to content


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.


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.


    Using the form

    When using the form a date range must be selected.



    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.


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.


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.



Clear the console

Toggle Source Expressions

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


For example, taking this kdb+/q query:

([] 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:



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



Tabulated results from the query; results are paged.


Display results from the start of the data source (page 1).
Display results from the end of the data source (last page).
Select a random point in the data set to display results.
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.



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


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.


Click the area above the chart to open menu.



Radius Data
Choose between a data source variable or Fixed sized bubbles.
Radius Scaling
Sets the scaling of bubble size.
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.
Plotted bubble data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.



Define the opacity of the line. Range 0 (transparent) to 100 (opaque).
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.
Plotted line data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.



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.
Plotted bar data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.

Color Palette


Define Hex color for each layer; plotted in order.



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.


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.


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


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


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.
Add a text component before or after y-axis tick label.
Hide Trailing Zeroes
When enabled, hides trailing zeroes from axis label.
Filter paged results by 10, 100, 1,000, or 10,000 results per page.