title: How to define an array variable in Snowflake
body: <p>How to define an array variable in snowflake worksheet?</p>
  <pre><code>set columns =  (SELECT array_agg(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS 
                  where table_name='MEMBERS');
  </code></pre>
  <p>I get this error:</p>
  <blockquote>
  <p>Unsupported feature 'assignment from non-constant source expression'.</p>
  </blockquote>