The web-console allows you to quickly interact with your data. In this guide, we will show you how to import data.
Accessing the Web Console
The Web Console will be available at
running locally, the console is available at
If you are running QuestDB from Docker, make sure you expose the port
By default, the Web Console opens on the SQL editor.
Using the editor
You can also insert data using the Import screen.
Create a table
Type the following SQL into the editor then click the
The editor will perform the query and perform feedback (success/failure, execution time).
You can also use :
Enter instead of
As you have noticed, you can insert multiple statements into the editor. However, only one will be run at a time. It uses the cursor position to determine which statement to run. To run a particular statement, click within this statement or highlight it.
We can now insert data. Let's insert some random temperatures from 4 different
places chosen at random in a list to simulate 4 sensors sending data. Note we
have to cast the row generator cursor to
int as it is of default type
dateadd() requires an
Let's now run a query. Copy/paste the following into the editor.
You can use the mouse selection to run subsets of a query. If part of a
statement is selected, the selected part will be executed. You can try by
SELECT ts, avg(tempC) FROM temp in the above query and running
Building queries with the table explorer
Now that you have created a table, it will appear in the table explorer on the left-hand side. You can use this tool to explore your tables, their columns, and respective types.
Add tables or columns to your query by clicking on the
add button next to the
You can run the above query again and now click on the
Chart button. This will
display the chart editor. You can then choose chart type, for example
draw. This will draw a chart for the series.
You can download your query results by clicking the
CSV button. This file will
be useful to test the import functionality below.
Let's now take a look at the import screen. It can be accessed by clicking this icon on the left-side navigation menu.
The Import screen allows you to instantly load data. QuestDB will automatically recognise the schema by analysing a sample of the data.
Locate the file you just downloaded in the previous step, and import it using either of the following methods:
- Drag and drop a
txtfile into the import screen
- Use the browse file function
Alternatively, you can open the file in excel, copy the data, and paste it in the import window.
The Web Console comes with more features such as schema editing. To find out more, consult our Web Console reference