Snowflake SQL Error with Multiple Arrays: Bind variable :1 not set

App Building
, ,
1

I'm trying to query multiple arrays that i built in a javascript transformer but keep running into the error when i have two conditions. it runs fine when i have one or the other conditions running at once.

SQL compilation error: error line 19 at position 17 Bind variable :1 not set.

Snowflake code

SELECT 
  card_id, 
  card_token,
  account_id,
  bin,
  last_four,
FROM 
INT_CARDS
WHERE 
  (last_four in ({{ cardParseArray.value.lastFoursString }}))
  and (bin in ({{ cardParseArray.value.binsString }}))
LIMIT 10

This is my javascript transformer

// Process binsString to be a comma-separated string of numbers
const binsString = {{table1.data
    .map(row => row.cardBin ? parseInt(row.cardBin.slice(0, 6), 10) : null)
    .filter(Boolean)
    }};

// Process lastFoursArray to be a comma-separated string of unique numbers
const lastFoursString = {{[...new Set(table1.data
    .map(row => row.cardLastDigits ? parseInt(row.cardLastDigits, 10) : null)
    .filter(Boolean))]
    }}; 

return {
  binsString: binsString, // Ensure this variable contains a comma-separated string of numbers
  lastFoursString: lastFoursString // Ensure this variable also contains a comma-separated string of numbers
};
2

@Ankit_Gandhi in case the responses with suggested SQL syntax on this other thread that mentions "Bind variable :1 not set" error help out with this, I thought I'd share the topic here! Passing array from selectedRows/multiselect using IN clause