I have tried every suggestion I've found on the community as well as the greater google-verse, but I still can't figure out how to create a WHERE statement with an array of values from a selection.
Here's the query with it typed out (which works!):
I totally didn't see the @ sign! Thanks for including a big screenshot of it.
This will help so many of my queries that are hitting snowflake that I've been thinking, "If only I could use that other query and do this one as a Query JSON with SQL!"
I'll let you know how it goes when I can get in (I have to wait for other team members to get out because, y'know... we can't develop at the same time. But I'm sure you get that request all the time. ;))