Athena - Execute multiple query and capture output in a file on e2

Question

Please help me on how to execute multiple query and capture the output in a file on e2 **Tried with :** `aws athena start-query-execution --query-string "

Answer

Hi,

If I understand correctly you would like to be able to save the result set,

the [`start-query-execution`](https://docs.aws.amazon.com/cli/latest/reference/athena/start-query-execution.html), will only return the query ID, you can use the query ID to check the status of a query (QUEUED,RUNNING, FAILED, SUCCEEDED) and retrieving the query result sets with different commands:

[get-query-execution](https://docs.aws.amazon.com/cli/latest/reference/athena/get-query-execution.html)

[get-query-results](https://docs.aws.amazon.com/cli/latest/reference/athena/get-query-results.html)

hope this helps,

Athena - Execute multiple query and capture output in a file on e2

Relevant content