, I have grafana, where my underlying database is AWS Timestream. I have around 20 widgets (panes) in my dashboard, which makes 20 calls to the datasource.
AWS prices 10mb minimum per query, which causes me to pay 200mb worth of queries instead of few MB which is the amount of data scanned.
What I want to do, is to run the a unified query (take the 20 queries and run them once with outer joins), then perform the queries of the panes against this result.
Is this even possible?