AWS Glue crawler only crawl the column name not the data

Question

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:

Output in Athena: only column name without data.

Answer 1

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.

Answer 2

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...