title: Snowflake SQL - How can I query with an array variable for an IN clause
body: <p>How can I set a variable as an array of values, that would be used in an IN clause?</p>
  <p>This works:</p>
  <pre><code>SELECT *
    FROM TableA
   WHERE Col1 IN ('Value1', 'Value2', 'Value3');
  </code></pre>
  <p>But I can't figure out how to create a variable from that manually specified array to use. I want to do something like this:</p>
  <pre><code>SET values = ('Value1', 'Value2', 'Value3');
  
  SELECT *
    FROM TableA
   WHERE Col1 IN $values;
  </code></pre>
  <p>The reported error:
  <code>SQL compilation error: Number of variables on left-hand side of assignment (1) is not equal to the number of values on right-hand side (3)</code></p>
  <p>So how can I create an arary variable for this purpose?</p>