QuestDB is a relational database management system that is designed for speed and performance. To establish a connection with QuestDB, you must first ensure that the server you are connecting from has the appropriate network access to reach the QuestDB database. This may require configuring your firewall or network settings, depending on your specific setup.
Once you have verified that the necessary access has been granted, you can proceed with providing the relevant information to establish the QuestDB connection. This will typically include details such as the database name, host address, and port number. If the table you wish to use is not yet created, or you need to make changes such as adding columns, you may need to select the appropriate option to create or modify a table.
By completing this process accurately and comprehensively, you can establish a successful connection with QuestDB and begin working with your data.
The table below provides an explanation and type of parameters that must be filled by the user to establish a connection with QuestDB. It outlines the specific parameters required and their corresponding data types, which must be correctly entered to successfully establish a connection with QuestDB.
Quest DB | ||
Host | Server Host | String |
Port | Server Port | Int |
DatabaseName | Name of database | String |
Schema | Schema name | String |
UserName (Optional) | Username to connect to server | String |
Password (Optional) | Password to connect to server | String |
JDBCConnectionString (Optional) | A connection string to connect to server | String |
Inputs | Connection Inputs | List |
Outputs | Connection Outputs | List |
Once the connection with the QuestDB source has been established successfully, the "input" page is utilized to define the data or dataset. This step involves specifying the necessary details related to the data or dataset, such as its location, type, and structure. Ensuring that all the relevant information is accurately entered on the "input" page to properly define the data or dataset is crucial for the successful transfer of data to a QuestDB table.
A detailed explanation of the Query Editor feature can be found in section 2.1 of this user manual. This feature enables tables and columns within your database to be easily navigated and selected, and then used in your SQL queries by typing the query in the editor section.
To view the results of the written query, refer to section 2.2, which covers the 'Execute Query' feature. This feature allows the user to execute the query and view the output in the result window, as described in the previous section. By combining the Query Editor feature with the ability to execute SQL queries, users can easily navigate their databases and select tables and columns to be used in their queries.
Input | ||
Query | Query to run | String |
To transfer the data package created by the user to a QuestDB table, it is necessary to define an output. If the table is not already present in the database or the user wishes to make modifications like adding columns to it, then they must choose the "Create Table" option. This allows the user to create a new table, by specifying the required details such as the table name, data type and size of the columns, and any constraints on the table. It is important to ensure that all the required information is accurately entered when creating a table in QuestDB. Once the table is created, the user can then use SQL queries to transfer data to the table or modify it as required.
Output | ||
TableName | Name of the table | String |
CreateTable | Whether to create a new table if it does not exist | Bool |