跳至內容

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.

已提問 1 年前檢視次數 465 次
1 個回答
1
已接受的答案

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

已回答 1 年前
專家
已審閱 1 年前
專家
已審閱 1 年前
  • 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!

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

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