Salta al contenuto

AWS Glue Crawler not extracting data from CSV file

0

I have a crawler that I'm trying to have extract headers and data from a CSV file. When I run the crawler and then use Athena to query the table it returns the no data. It seems to only extract the headers of the CSV file. The CSV file is the Stackover flow annual developer survey, which can be found here: https://survey.stackoverflow.co/. I try adding a Classifier but the results are the same. The data source is a CSV file within a S3 bucket and the crawler has permissions to list buckets, get and put objects as well as AWSGlueServiceRole.

posta un anno fa478 visualizzazioni
1 Risposta
1
Risposta accettata

I had to specify the folder and not the actual file.

con risposta un anno fa
ESPERTO
verificato un anno fa
ESPERTO
verificato un anno fa
  • Hi Meddy, I am having the same issue and don't quite understnad what you mean. Do you mean change the S3 path to specify the folder that the CSV files are in rather than the actual file? Because if so I already have that. If that is not what you mean please do explain further!

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.