How to filter on an array in Snowflake
I have a data that has an array with values enclosed with ‘double quotes’:
{“apple”, “banana”, “orange”} and I want to query the data where there are only “apple”
I tried using
I have a data that has an array with values enclosed with ‘double quotes’:
{“apple”, “banana”, “orange”} and I want to query the data where there are only “apple”
I tried using