'Why AWS Glue crawler does not crawl the data from datalake s3 bucket into single schema?

In redshift spectrum, while querying data it throws error . because table has duplicate column name Glue crawler- does not crawl the schema into single schema even though i configure the crawler properly for "Create a single schema for each S3 path"



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source