Relative Content

Tag Archive for sqlarrayssnowflake-schema

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