Flatten a LIST of objects


I’m trying to flatten a list of objects and getting into this issue. I’ve searched in the community and online but couldn’t find anything similar.

The column type has a A # type, regards the brackets and attempting to cast it to LIST getting a “Unknown datatype name ‘LIST’” error.
Please advice.

Thank you

Flatten will work on Json Arrays. https://docs.dremio.com/sql-reference/sql-functions/nested-data.html.
Please share how the actual data in the column you are applying Flatten to looks like.

Note you may also be able to use the UNEST transformation as shown on https://docs.dremio.com/working-with-datasets/data-curation.html