Best practice to work with QuickSight and Athena array data type

Question & Answer
, ,
1

Hi,

since It seems that QuickSight doesn’t support the Athena array data type, which are the best practice to work with arrays in QuickSight. Let’s say I have in my data a column “tags” which needs to be an array of strings, do you suggest to store it as a stringified JSON array or to save it as an array data type and do some sort of casting in the dataset preparation query?
The string data in the array need to be used in analysis… what do you suggest?
Thank you!

2

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