I am using Amazon Appflow to transfer data between Datadog and AWS. Each appflow uses a query related to a single monitor in Datadog (such as a metric monitor, or an anomaly monitor). However, we have a huge amount of monitors in Datadog, and from my experimentation, multiple queries can't be used per appflow, so the only straightforward solution is to create the same amount of appflows as monitors in Datadog.
I do not see this as a very efficient solution, considering the amount of monitors being used. Is there any workaround to this dilemma? If there is a solution besides appflow I will be more than happy to learn about it. Thank you.