CODEWITHSUNDEEP
influxdb
Murthi
Murthi

Reputation: 71

How to copy an Influx measurement to new measurement in different database?

Trying to copy one measurement data from different measurement in different influxDB, not finding any queries I have query to copy from one measurement to other measurement in same database but need different database.

Kindly suggest...

Upvotes: 2

Views: 3702

Answers (1)

tomgalpin
tomgalpin

Reputation: 2099

You can specify the database name within the INTO clause. see https://docs.influxdata.com/influxdb/v1.7/query_language/data_exploration/#the-into-clause.

INTO <database_name>.<retention_policy_name>.<measurement_name> Writes data to a fully qualified measurement. Fully qualify a measurement by specifying its database and retention policy.

INTO <database_name>..<measurement_name> Writes data to a measurement in a user-specified database and the DEFAULT retention policy.

Upvotes: 0

Related Questions