How to write an Athena query to output tables to CSV files?

0

We have an Athena DB that contains 139 tables and as a one time test I need to ingest the data from each table into Splunk. Is there a query that would pull the output from each individual table and write it out as it’s own CSV file (as table name) so that I would have 139 CSV files? We currently save Athena queries to a separate s3 bucket.

1 Answer
0
profile pictureAWS
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions