CODEWITHSUNDEEP
amazon-web-servicesaws-glueamazon-athenaglue-crawler
SSS
SSS

Reputation: 83

AWS Glue crawler only crawl the column name not the data

I have multi level json file which i have converted into CSV using Glue job. Now i am trying to use crawler on that CSV file, the crawler create the glue table properly (Shows status 1 created). But when i check this table in Athena it only shows the column names of table, it doesn't show any data. during crawler creation i have used classifier as comma, still its not working. Any idea, suggestion to work with this issue? please find attached screenshot of CSV. also find the attached screenshot output in Athena.

input CSV: enter image description here

Output in Athena: only column name without data. enter image description here

Upvotes: 0

Views: 895

Answers (2)

gondf
gondf

Reputation: 1

We use the crawler to obtain the schema of your data and create a data catalog. With this data catalog, you can read your data with Job Glue or Athena...

Upvotes: 0

SSS
SSS

Reputation: 83

I got the solution, i don't get the logic. Normally in crawler i used to select the file as source data, but this time i select folder name and it worked.

Upvotes: 0

Related Questions