How do I resolve the error "schema validation failed: failed to infer Glue columns" in Panther?
Issue
When trying to infer a new schema from a JSON log file, I got this error message:
schema validation failed: failed to infer Glue columns for "xxx": schema error at "xxx": column name collision "xxx": [xxx]
Resolution
To resolve this issue you can use the rename transformation in the schema fields that are generating this conflict.
Cause
This issue occurs when there are multiple fields with the same name resulting in a column collision in the proposed (from the schema inferring) database table.