The REST API provides an
/imp endpoint exposed on port
9000 by default. This
endpoint allows streaming tabular text data directly into a table, supporting
CSV, TAB and pipe (
|) delimited inputs with optional headers. Data types and
structures are detected automatically, but additional configurations can be
provided to improve automatic detection.
The REST API is better suited when the following conditions are true:
- Regular uploads of small batches of data into the same table.
- The file batches do not contain overlapping periods (they contain distinct days/weeks/months). Otherwise, the import performance will be impacted.
It is possible to upload compressed files directly without decompression:
data=@- value instructs
curl to read the file contents from
schema JSON object can be provided with POST requests to
creating tables via CSV import. This allows for more control over user-defined
patterns for timestamps, or for explicitly setting types during column-creation.
The following example demonstrates basic usage, in this case, that the
ticker_name column should be parsed as
SYMBOL type instead of
If a timestamp column (
ts) in this CSV file has a custom or non-standard
timestamp format, this may be included with the call as follows:
For nanosecond-precision timestamps such as
2021-06-22T12:08:41.077338934Z, a pattern can be provided in the following
More information on the patterns for timestamps can be found on the date and time functions page.
schema object must precede the
data object in calls to this REST
endpoint. For example:
QuestDB uses a
text_loader.json configuration file which can be placed in the
conf directory. This file does not exist by default, but has the
following implicit settings:
Given a CSV file which contains timestamps in the format
yyyy-MM-dd - HH:mm:ss.SSSUUU, the following text loader configuration will
provide the correct timestamp parsing:
The CSV data can then be loaded via POST request, for example, using cURL:
For more information on the
/imp entry point, refer to the
REST API documentation.