influxdb data/table be downloaded as csv file?

database csv influxdb
surya rahul picture surya rahul · Jun 9, 2018 · Viewed 14.4k times · Source

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?

Answer

surya rahul picture surya rahul · Jun 14, 2018

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

Related questions

Export table from database to csv file

I want to: Export table from sql server database to a comma delimited csv file without using sql Server import export wizard I want to do it using a query because I want to use the query in automation Is …

Read More
How to use mongoimport to import csv

Trying to import a CSV with contact information: Name,Address,City,State,ZIP Jane Doe,123 Main St,Whereverville,CA,90210 John Doe,555 Broadway Ave,New York,NY,10010 Running this doesn't seem to add any documents to the database: $ mongoimport -d mydb …

Read More
Importing a CSV file into a sqlite3 database table using Python

I have a CSV file and I want to bulk-import this file into my sqlite3 database using Python. the command is ".import .....". but it seems that it cannot work like this. Can anyone give me an example of how to …

Read More