Can't filter SQL result by array - Snowflake

Hey @Steven_Shoemaker! Using arrays in snowflake can be a bit tricky in Retool. We have a post here that goes into some of the different SQL syntax for arrays.

For your query, this syntax should work:

Using the values from this multiSelect:

Let me know if you have any questions!

1 Like