Convert Strings to Array


Is there a way to convert Strings to Arrays in Athena? So that I can pass a List as String as a parameter and use the IN Operator to prove if a column is one of the list values.


This worked for me:

SELECT “virtualdevice”
SELECT split(’{{devices}}’, ‘,’) AS items
UNNEST (items) as t(virtualdevice)