Import data into TimescaleDB from .csv

Importing data

1. Connect to your database and create a new empty table. Use a schema that matches the data in your .csv file. In this example, the .csv file contains the columns time, location, and temperature.

   CREATE TABLE <TABLE_NAME> (
       ts        TIMESTAMPTZ           NOT NULL,
       location    TEXT                NOT NULL,
       temperature DOUBLE PRECISION    NULL
   );

   Copy
2. Convert the empty table to a hypertable using the create_hypertable function. Replace ts with the name of the column storing time values in your table.

   SELECT create_hypertable('<TABLE_NAME>', 'ts')

   Copy
3. At the command line, insert data into the hypertable from your csv. Use timescaledb-parallel-copy to speed up migration. Adjust the number of workers as desired. Alternatively see the next step.

   timescaledb-parallel-copy --db-name <DATABASE_NAME> --table <TABLE_NAME> \
       --file <FILENAME>.csv --workers 4 --copy-options "CSV"

   Copy
4. OPTIONAL If you don't want to use timescaledb-parallel-copy, insert data into the hypertable by using PostgreSQL's native COPYcommand. At the command line, run:

   psql -d <DATABASE_NAME> -c "\COPY <TABLE_NAME> FROM <FILENAME>.csv CSV"

   Copy