title: Convert an array of strings to an array of numbers in Snowflake
body: <p><strong>How does one convert an array of string values into an array of numbers?</strong></p>
  <p><strong>Background:</strong></p>
  <p>Using Snowflake, I have a string input like &quot;123, 45, 89&quot; that I want to convert to an array of numbers (123, 45, 89) so that I can eventually compare against an int column like</p>
  <pre><code>WHERE id IN ( array of number here)
  </code></pre>
  <p>I think I can use <code>SPLIT('123, 45, 89', ',')</code> to get an array of strings, but get an error like this:</p>
  <blockquote>
  <p>SQL compilation error: Can not convert parameter 'SPLIT(?, ',')' of type [ARRAY] into expected type [NUMBER(38,0)]</p>
  </blockquote>
  <p>For context, I am using Metabase, with a text filter as input to add those ids.</p>