I am crawling a S3 bucket using AWS Glue crawler which creates table schema in Athena. I understand Athena does not support column names which has special characters like (backward slash) etc. Is their a way which can exclude/rename these column name while crawler is crawling from S3 bucket. I have few columns names like (RelatedAWSResources:0/name) which gives me error when I query in Athena. Any help is appreciated.
1 Answers
Sadly, there is no such way. What you could probably do is to setup AWS Glue Job, and transform all your data to a format that is suitable for Athena.
Related