CODEWITHSUNDEEP
amazon-web-servicesamazon-s3amazon-athena
haneulkim
haneulkim

Reputation: 4928

Are result of queries using AWS Athena through AWS QuickSight stored in S3?

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!

Upvotes: 3

Views: 819

Answers (2)

Henrik Koberg
Henrik Koberg

Reputation: 146

This answer comes a bit late but it says in the Quicksight documentation:

"The Athena workgroup must have an associated S3 output location."

So it seems Quicksight stores query results of a particular data source always in the bucket which is configured as output location for the Athena workgroup which is associated to this data source.

Upvotes: 0

Theo
Theo

Reputation: 132922

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).

Upvotes: 3

Related Questions