Querying CSV files

0

Hello, I have CSV files stored in S3 buckets. I run a crawler that crawls in the bucket and creates tables according to the CSV files. When I run these tables in ATHENA AWS the tables are empty (although there is data in the CSV files). how can I solve it?

Thanks in advance, Mia

Topics

Tags

Language

English

rePost-User-2540619

asked a month ago516 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

0

as an alternative solution, you can follow this document https://docs.aws.amazon.com/athena/latest/ug/csv-serde.html https://docs.aws.amazon.com/athena/latest/ug/glue-best-practices.html

EXPERT

answered a month ago

EXPERT

Giovanni Lauria

reviewed a month ago

Relevant content

CSV crawler tables name
Jess
asked 2 years ago
How to read from CSV files in S3 that have headers?
Accepted Answer
mkamp
asked 6 years ago
Quering CSV file in Athena
rePost-User-2540619
asked 2 months ago
How to write an Athena query to output tables to CSV files?
rePost-User-jrw
asked a year ago
How can I store an Amazon Athena query output in a format other than CSV, such as a compressed format?
AWS OFFICIALUpdated 2 years ago
How can I set the number or size of files when I run a CTAS query in Athena?
AWS OFFICIALUpdated 3 years ago
How can I prevent the AWS Glue crawler from creating multiple tables?
AWS OFFICIALUpdated a year ago
How can I see the Amazon S3 source file for a row in an Athena table?
AWS OFFICIALUpdated 2 years ago
Migrating Glue Data Catalog tables to use Apache Iceberg open table format using Athena
EXPERT
Hamzah Chaudhry
published 14 days ago
Returning AWS Config aggregator results as CSV
EXPERT
James_S
published 2 years ago