Search code examples
databasecsvinfluxdb

influxdb data/table be downloaded as csv file?

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?

Solution

  • 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