Hi, we would like to see the amount of scanned dat...
# ask-questions
m
Hi, we would like to see the amount of scanned data or processed bytes per metric on the `Queries`Modal as shown in the attached image. Is this possible? or should we use the statistics object of the Query Model? If so, how do we enable these statistics? Thanks.
f
Hi Fabian - let me check with the team
f
I assume this is for Athena? We implemented this a while ago for BigQuery (https://github.com/growthbook/growthbook/pull/2042).
m
@future-teacher-7046 yes, for Athena.
f
It looks like Athena does expose an API we could call. https://docs.aws.amazon.com/athena/latest/APIReference/API_GetQueryRuntimeStatistics.html However, the warning at the top makes me think it won't reliably contain bytes scanned at the point when we fetch it.
The remaining non-timeline statistics in the response [...] are updated asynchronously and may not be available immediately after a query completes
As an alternative, we could deep link into the AWS console from our View Queries modal and take you directly to the query stats. Would that work for you?
m
@future-teacher-7046 It would be great to show the bytes scanned if available, if you can link to the query stats as a fallback it would also work for us.
@future-teacher-7046 is there any update on this feature? We want to have it since cost savings is now crucial for 2025 and we want our users to be aware of the main driver of the cost (scanned data).