title: How to get the full results of a query to CSV file using AWS/Athena from CLI?
body: <p>I need to download a full table content that I have on my AWS/Glue/Catalog using AWS/Athena. At the moment what I do it is running a <code>select * from my_table</code> from the Dashboard and saving the result locally as CSV always from Dashboard. Is there a way to get the same result using AWS/CLI?</p>
  <p>From the documentation I can see <a href="https://docs.aws.amazon.com/cli/latest/reference/athena/get-query-results.html" rel="nofollow noreferrer">https://docs.aws.amazon.com/cli/latest/reference/athena/get-query-results.html</a> but it is not quite what I need.</p>