Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

CSV crawler tables name

0

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

Topics
AnalyticsDatabaseStorage
Tags
Extract Transform & Load DataAWS GlueAmazon Simple Storage Service
Language
English
asked 4 years ago1.5K views
1 Answer
0

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.

AWS
SUPPORT ENGINEER
answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content