Snowflake IN operator: issues with more than one IN operator with bound variables

[AbbeyHernandez]

Hi @sgodoshian,

Maybe you could use ARRAY_CONTAINS() here.

SELECT
  *
FROM
  PUBLIC.USERS
WHERE
  ARRAY_CONTAINS(ID::variant, SPLIT( {{[123,224].join()}}, ',') )

SQL Cheatsheet