I have high rate data, and over time I want to eliminate old data and instead store lower rate aggregate data. Exact intended use case for CQs and retention policies. Great.
However, some data I want to keep forever no matter their age. Specifically, I want to keep the previous X minutes of full rate data prior to a fault. Fault event records are also stored in InfluxDB.
What’s the best way to achieve this in InfluxDB 1.6? Is it possible to automate with CQs or should I plan to deliberately execute a custom query to achieve this (say, after each fault is detected)? If so, what would such a query look like?