"in" statement in snowflake only pulling first entry?

Hi @philippe-boyd-maxa, this has been identified as bug. you can follow their updates on this in this thread.

You probably want to use ARRAY_CONTAINS() instead of in. Check this tips and tricks thread on how to navigate with IN or similar functions/operators.

Regards