select *
from mytable
where array_contains(likes_and_preferences,'item') = TRUE
You may also like
Local copy existing extractUse local copy source Close old extract (optional)Edit data source based on local copy
select str_to_map(column,’,’,’:’) from table ;