Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

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.

Topics
AnalyticsDatabase
Tags
AnalyticsExtract Transform & Load DataAmazon AthenaDatabase
Language
English

asked 4 years ago1.7K views

1 Answer
0

select * from table_name or https://docs.aws.amazon.com/cli/latest/reference/athena/start-query-execution.html

AWS

answered 4 years 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.

Relevant content