Dear InfluxDB Experts,
I can’t find in their documentation, is there any limit of the number of Continuous queries (CQ) for a specific database?
For example, I have “myDB” with thousands of measurements, I want to create a CQ for each
measurement. So my question is :
- Will it be possible to create that? The CQ is simple getting the average values and write it into another database.
- If this is possible, is there any way to template the CQ? As I said, the query is just getting average value for each measurement, so basically the syntax is just repeated for each measurement, will it be possible to create a CQ templates that runs on each measurements? for example:
CREATE CONTINUOUS QUERY “cq_measurement_name” on “dbname”
SELECT mean(“value”) INTO “db2.measurement_name” FROM “measurement_name” GROUP BY time (1m)
So my CQ is something like that, it is just time-consuming on my side to create thousands of queries like that, I hope there is another way to make the creation faster since the query has a pattern.
Thank you Experts!