CSV crawler tables name

Question

Hi team,

I have an issue with the glue crawler, when I leave in my S3 bucket only 1 CSV file and run the CSV crawler, it generates the crawled table with the name of the s3 bucket itself non with the name of my CSV file.

When I have 1+ files in the bucket I have the crawled table that have the same names as the CSV files but if I have only 1 file on my s3 bucket the crawled table takes the name of the s3 bucket not of the crawled file.

any idea to resolve that issue?

Thanks

Answer

By default, if a prefix contains 1 or more files of similar schema, Crawler creates one table with name as that of parent prefix.

However, if the crawler is not able to determine similar schema between the files under a prefix, it will create multiple tables each with name similar to the file name.

CSV crawler tables name

Relevant content