I have some CSV data that have an array of strings. For example, I want to extract two columns:
USGLS,"['MXMAR', 'BZBZE', 'MXCZM']",TEST
Unfortunately, the Glue CSV crawler (after executing it) determines the second column to be a string. Moreover, the crawler believes the second column value is:
"['MXMAR'
while the third column value is:
'BZBZE'
Editing the schema for the data catalog doesn't allow me to change the data type of the column to an array type. How can I change the column data type to an array of strings?