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 2 months ago532 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 2 months ago

EXPERT

Giovanni Lauria

reviewed 2 months ago

Relevant content

How to write an Athena query to output tables to CSV files?
rePost-User-jrw
asked 2 years ago
How to read from CSV files in S3 that have headers?
Accepted Answer
mkamp
asked 6 years ago
CSV crawler tables name
Jess
asked 2 years ago
Quering CSV file in Athena
rePost-User-2540619
asked 2 months 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 see the Amazon S3 source file for a row in an Athena table?
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
Returning AWS Config aggregator results as CSV
EXPERT
James_S
published 2 years ago
Migrating Glue Data Catalog tables to use Apache Iceberg open table format using Athena
EXPERT
Hamzah Chaudhry
published a month ago