Web Console

Web Console

The Web Console is a client that allows you to interact with QuestDB. It provides UI tools to query data and visualize the results in a table or plot.

Screenshot of the Web Console

Accessing the Web Console

The Web Console will be available at http://[server-address]:9000. When running locally, this will be http://localhost:9000.

Layout

Preview of the different sections in the Web Console

System tables in Schema explorer

It is possible to hide QuestDB system tables (telemetry and telemetry_config) in Schema explorer by setting up the following configuration option in a server.conf file:

/var/lib/questdb/conf/server.conf
telemetry.hide.tables=true

Code editor

The default panel shown in the web console is the code editor which allows you to write and run SQL queries.

Shortcuts

CommandAction
Run queryf9 or ctrl/cmd + enter
Locate cursorf2, use this to focus the SQL editor on your cursor in order to locate it

Behavior

As you can write multiple SQL commands separated by a semicolon, the Web Console uses the following logic to decide which queries to execute:

  • Check if a query or part of a query is highlighted. If yes, it will be executed, otherwise:
  • Check if the cursor is within a SQL statement. If yes, the statement will be executed, otherwise:
  • Check if the cursor is on the same line as a SQL statement and after the semicolon. If yes, this statement will be executed, finally:
  • If the cursor is on a line that does not contain a SQL statement, the next encountered statement will be executed. If there is no statement after the cursor, the previous statement will be used.

Visualizing results

You can run a query and click on the Chart button. This will display the chart editor. You can then choose chart type, for example, line and then press Draw.

Toggle the grid table

The following options are available to toggle the grid layout:

Preview of the different sections in the Web Console
  • Freeze left column:

    To freeze more columns, drag the vertical solid line to the desired column

    Screenshot of the freeze-column line
  • Move the selected column to the front

  • Reset grid layout

  • Refresh

Downloading results

You can download the query result by clicking the CSV button. This file will be useful to test the import functionality below.

Notification panel

The panel at the bottom of the web console shows the status of the most-recent query. This panel can be toggled by clicking the up-arrow icon on the right of the panel and shows the last 20 messages and notifications after query execution.

Screenshot of the Web Console showing the location of the notification panel

Import

The Web Console offers an interface to import small batches of CSV files as new tables or to existing tables.

The import tab can be accessed by clicking this icon on the left-side navigation menu:

Screenshot of the Web Console showing the location of the Import tab

The import UI:

Screenshot of the UI for import

Import configurations

Once a file is added to the Upload queue, the following configurations will be displayed:

Screenshot of the Web Console showing the file ready to be uploaded
  • File: The file name, size, and the import status
  • Table name: The name for the table to be imported. By default, this is the name of the imported file.
  • Schema: The Colum data name and data type. The schema is automatically detected but it is possible to set it manually. See Table schema for more information.
  • Write mode:
    • Append: Uploaded data will be appended to the end of the table.
    • Overwrite: Uploaded data will override existing data in the table
  • Actions:
    • Settings: Additional configuration for the import. See Import settings for more information.
    • Upload: Start the upload
    • X: Delete the file from the Upload queue
Table schema

To update the schema of an existing table, select Overwrite write mode to replace the rows and the partition unit with the CSV file.

For an existing table, changing the table name allows importing it as a new separate table.

The following setting is available for configuration for both existing and new table import:

SettingDescription
PartitionChange the partition setting of the table.
Designated timestampElecting a Designated timestamp. This is mandatory if the partition unit is not NONE.
Data typeDefine the data type. For timestamp, the timestamp format is mandatory and there is the option to elect the column as the designated timestamp.

To update the schema of a new table, in addition to the above, the following settings are also available for configuration:

SettingDescription
Delete columnClick x to delete the column from the table.
Add columnAt the end of the column list, select “Add column” to insert a new column into the table.

The following table schema details are imported based on the csv file:

  • The column order
  • The column name
Import settings

The Settings panel displays the following configurations:

SettingDescriptionDefault value
Maximum number of uncommitted rowThe size of the commit batch. A commit will be issued when this number is reached in the buffer. This setting is the same as cairo.max.uncommitted.rows. To avoid running out of memory during an import, set this value based on the RAM size of the machine.500000
DelimiterThe delimiter character to parse the CSV file.Automatic
AtomicityError behavior. Rejected rows or columns will be reported in the Details panel after the import is completed.Skip column
Force headerWhether to interpret the first line as the header. The result will be reported in the Details panel after the import is completed.FALSE
Skip line extra valuesWhether the parser should ignore extra values by ignoring the entire line. An extra value is something in addition to what is defined by the header.FALSE

Import details

The import status is displayed in the file column. Once the action is completed, the number of rows inserted is displayed alongside the Details tab:

Screenshot of the Web Console showing number of row imported and the Details tab

The Details panel lists rejected rows and errors in importing each column:

Screenshot of the Web Console showing the import details

The details such as header forced, table name, and rejected rows are related to the defined import settings. For example, setting Atomicity in Settings to Skip row will result in skipped rows being reported in Rejected rows after the import.

Create table

The "Create" tab on the top of the page allows table creation using interactive UI:

Screenshot of the create table tab

Use the create table panel to define table partition, WAL setting, and add column to a new table:

Screenshot of the create table panel

Providing an asset path

It's possible to provide an asset path if QuestDB is being run from somewhere that is not the server root. In this case, create a .env file in the UI directory of QuestDB and provide the path to web console assets as follows:

ASSET_PATH=/path/to/questdb/ui

An example dotenv file is provided which can be renamed to .env and placed in QuestDB's UI directory.