Migrate data to TimescaleDB from InfluxDB
You can migrate data to TimescaleDB from InfluxDB using the Outflux tool. Outflux is an open source tool built by Timescale for fast, seamless migrations. It pipes exported data directly to TimescaleDB, and manages schema discovery, validation, and creation.
Outflux works with earlier versions of InfluxDB. It does not work with InfluxDB 2.X.
Before you start, make sure you have:
- A running instance of InfluxDB and a means to connect to it.
- An installation of TimescaleDB and a means to connect to it.
- Data in your InfluxDB instance. If you need to import some sample data for a test, see the instructions for importing sample data.
To import data from Outflux, follow these procedures:
- Install Outflux
- Import sample data to InfluxDB if you don't have existing data.
- Discover, validate, and transfer schema to TimescaleDB (optional)
- Migrate data to TimescaleDB
Install Outflux from the GitHub repository. There are builds for Linux, Windows, and MacOS.
- Go to the releases section of the Outflux repository.
- Download the latest compressed tarball for your platform.
- Extract it to a preferred location.
If you prefer to build Outflux from source, see the Outflux README for instructions.
To get help with Outflux, you can run
./outflux --help from the directory
where you installed it.
If you don't have an existing InfluxDB database, or if you want to test on a sample instance, you can try Outflux by importing sample data. We provide an example file with data written in the Influx Line Protocol.
Download the sample data:
Use the Influx CLI client to load the data into InfluxDB.influx -import -path=outflux_taxi.txt -database=outflux_tutorial
This command imports the data into a new database named
The sample data has no timestamp, so the time of the Influx server is used at data insert. All data points belong to one measurement,
taxi. The points are tagged with
vendor. Four fields are recorded:
tolls. The Influx client assumes the server is available at
- Discover the schema of an InfluxDB measurement
- Validate whether a TimescaleDB table exists that can hold the transferred data
- Create a new table to satisfy the schema requirements if no valid table exists
migrate command does schema transfer and data migration in one step. For more information, see the migrate section. Use this section if you want to validate and transfer your schema independently of data migration.
To transfer your schema from InfluxDB to TimescaleDB, run
outflux schema-transfer <DATABASE_NAME> <INFLUX_MEASUREMENT_NAME> \--input-server=http://localhost:8086 \--output-conn="dbname=tsdb user=tsdbadmin"
To transfer all measurements from the database, leave out the measurement name argument.
This example uses the
postgres user and database to connect to the TimescaleDB database. For other connection options and configuration, see the Outflux Github repo.
schema-transfer can use 1 of 4 schema strategies:
ValidateOnly: checks that TimescaleDB is installed and that the specified database has a properly partitioned hypertable with the correct columns, but doesn't perform modifications
CreateIfMissing: runs the same checks as
ValidateOnly, and creates and properly partitions any missing hypertables
DropAndCreate: drops any existing table with the same name as the measurement, and creates a new hypertable and partitions it properly
DropCascadeAndCreate: performs the same action as
DropAndCreate, and also executes a cascade table drop if there is an existing table with the same name as the measurement
You can specify your schema strategy by passing a value to the
--schema-strategy option in the
schema-transfer command. The default
By default, each tag and field in InfluxDB is treated as a separate column in
your TimescaleDB tables. To transfer tags and fields as a single JSONB column,
use the flag
Transfer your schema and migrate your data all at once with the
For example, run:
outflux migrate <DATABASE_NAME> <INFLUX_MEASUREMENT_NAME> \--input-server=http://localhost:8086 \--output-conn="dbname=tsdb user=tsdbadmin"
The schema strategy and connection options are the same as for
schema-transfer. For more information, see the
outflux migrate also takes the following flags:
--limit: Pass a number,
--limitto export only the first
Nrows, ordered by time.
to: Pass a timestamp to
--toto specify a time window of data to migrate.
chunk-size: Changes the size of data chunks transferred. Data is pulled from the InfluxDB server in chunks of default size 15 000.
batch-size: Changes the number of rows in an insertion batch. Data is inserted into TimescaleDB in batches that are 8000 rows by default.
For more flags, see the Github documentation for
migrate. Alternatively, see the command line help:
outflux migrate --help
Found an issue on this page?Report an issue!