Menu
Influxdb is a time series database which stores data and its attributes in the tables, commonly known as measurements.
Can the tables in databases of influxdb be fetched to local system in csv format?
941
Export a task in the InfluxDB UI Select Export. Downloading or save the task export file using one of the following options: Click Download JSON to download the exported JSON file.
InfluxDB data elements are stored in time-structured merge tree (TSM) and time series index (TSI) files to efficiently compact stored data. InfluxDB also provides a tabular data schema that includes the following: Annotation rows.
The storage engine handles data from the point an API write request is received through writing data to the physical disk. Data is written to InfluxDB using line protocol sent via HTTP POST request to the /api/v2/write endpoint or the /write 1. x compatibility endpoint.
In CLI following command can be used to download tables on the local system:
influx -database 'database_name' -execute 'SELECT * FROM table_name' -format csv > test.csv
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With