1

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.

2

This worked for me:

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