Multi-select value passthrough to SQL

[Paulo]

Hi @Rocky_Gowni, welcome to the forum!

To use arrays in SQL for a Snowflake resource, we want to use this syntax:

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

Here is our SQL Cheatsheet.