Best practice to work with QuickSight and Athena array data type

Most of the time we unnest the array so that every value becomes it’s own row and we get a type. In this case you would have a column that would be “tags” and you could group by a tag, filter, and many other actions.

https://prestodb.io/docs/current/sql/select.html#unnest

1 Like