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
Amazon AthenaAnalyticsDatabaseExtract Transform & Load Data
Language
English
rePost-User-jrw
asked 3 years ago1.4K views
1 Answer
0

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

profile pictureAWS
rePost-User-2606351
answered 3 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.

Guidelines for Answering Questions

Relevant content