How to handle field mismatch

I’m working with JSON fields and it seem that one of the fields has a mapping conflict in some of the fields.

Unable to coerce from the file’s data type “struct<options::list<struct<name::varchar, value::varchar>>, handle::varchar, title::varchar, id::varchar, sku::varchar, image::varchar>” to the column’s data type “varchar” in table “<table>”, column “line_items.properties.value” and file “<file>”

The line_items is an array of objects. I want to flatten the array and extract specific fields (sku, price, etc).

How do I work around this?

bump - any ideas/advice?

@yehosef-tw Sorry for the delay in response,

Is your file format PARQUET? it looks like you have heterogenous schema across files. Is that true?

Sorry for the delay - it’s raw json.