使用 AWS re:Post 即表示您同意 AWS re:Post 使用條款
AWS re:Postre: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.

主題
分析資料庫
標籤
Amazon Athena分析資料庫提取轉換與載入資料
語言
English
rePost-User-jrw
已提問 1 年前檢視次數 743 次
1 個回答
0

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

profile pictureAWS
rePost-User-2606351
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋，同時有助於提問者的專業成長。

回答問題指南

相關內容