I've checked AWS FAQ, and other resources however cannot find an answer to it. I can contact AWS for technical support however I do not have permission.
I've checked S3 that stores query results from Athena however it does not seem to have query results from queries using Athena via QuickSight.
Is there somewhere else Athena via QuickSight stores there query results?
thanks!
Athena always stores query results on S3. QuickSight probably just uses a different bucket. There should be queries from QuickSight in the query history (possibly in a work group that is not the primary), if you look at the query execution of one of these you should be able to figure out where the output is stored (e.g. aws athena get-query-execution --region AWS_REGION --query-execution-id ID and look for OutputLocation in the result).
