How to check list of string present Another Column

[Rahul]

Hi,

I have one requirement in this there is one API return list of values comma separated and Another column coming from Snowflake and I need to compare and generate a flag
Note : order of strings are not fixed
Example Column1: [‘STRING1’,‘STRING2’,‘STRING3’,‘STRING4’]

Column2: [‘STRING1’,‘STRING2’,‘STRING3’,‘STRING4’]

[Rahul]

There is a slight requirement change. I have to check guam column values in 360 columns and if all values of guam present in 360 then return true else false

“360”: “A,B,C,D,F”

Guam": “A,B,C,D”