title: how to send values to snowflake procedures array_construct field
body: <pre><code> EXECUTION 
          try:
              session = self.get_session()
              session.execute(&quot;BEGIN TRANSACTION;&quot;)
              if with_result:
                  output = session.execute(query, values)
                  result = output.mappings().all()
              session.execute(&quot;commit;&quot;)
              print(&quot;result = &quot;, result)
              return result
  
  FUNCTION 
   def insert_data(self, data ):
          y = list(data)
          values = {'data_assets': [y]}
          query = &quot;call data_table(:data_assets);&quot;
          self.database.execute_query(query,values)
          
  PROCEDURE
  create or replace data_table(data_val array)
  returns Table()
  language sql
  {code}
  
    
  VALUE PASSED TO THE FUNCTION
          k = {&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL_MAIL&quot;,&quot;EMAIL&quot;],&quot;id&quot;:1,&quot;size&quot;:50,&quot;pers_id&quot;: 081945}', '{&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL_MAIL&quot;,&quot;PHONE_NO&quot;],&quot;id&quot;:1,&quot;size&quot;:70,&quot;pers_id&quot;: 081945}', '{&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;MANAGER&quot;,&quot;USER&quot;],&quot;id&quot;:1,&quot;size&quot;:40,&quot;pers_id&quot;: 081945} ', '{&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL_MAIL&quot;,&quot;VIN&quot;],&quot;id&quot;:1,&quot;size&quot;:120,&quot;pers_id&quot;: 081945}', ' {&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL_MAIL&quot;,&quot;USER&quot;],&quot;id&quot;:1,&quot;size&quot;:500,&quot;pers_id&quot;: 081945} ', ' {&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PII&quot;,&quot;EMAIL&quot;,&quot;PERSONAL_MAIL&quot;,&quot;USER&quot;],&quot;id&quot;:1,&quot;size&quot;:20,&quot;pers_id&quot;: 081945}', '{&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL &quot;,&quot;EMAIL&quot;,&quot;EMPLOYEE&quot;,&quot;USER&quot;],&quot;id&quot;:1,&quot;size&quot;:70,&quot;pers_id&quot;: 081945} ', ' {&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL_MAIL&quot;,&quot;US_PHONE_NO&quot;],&quot;id&quot;:1,&quot;size&quot;:80,&quot;pers_id&quot;: 081945}', ' {&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL_MAIL&quot;,&quot;LOCATION&quot;],&quot;id&quot;:1,&quot;size&quot;:5,&quot;pers_id&quot;: 081945}', ' {&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;ADDRESS&quot;,&quot;USER&quot;],&quot;id&quot;:1,&quot;size&quot;:90,&quot;pers_id&quot;: 081945}', ' {&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL_MAIL&quot;,&quot;ADMIN&quot;],&quot;id&quot;:1,&quot;size&quot;:1,&quot;pers_id&quot;: 081945} '
  
  </code></pre>
  <p>ERROR:</p>
  <p>sqlalchemy.exc.ProgrammingError: (snowflake.connector.errors.ProgrammingError) 001003 (42000): SQL compilation error:
  syntax error line 1 at position 59 unexpected '&quot;path&quot;'.
  syntax error line 1 at position 76 unexpected '['.
  syntax error line 1 at position 87 unexpected ','.
  syntax error line 1 at position 134 unexpected ']'.</p>
  <p>[SQL: call data_table(%(data_assets)s);]
  [parameters: {'data_assets': [['{&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL  _MAIL&quot;,&quot;EMAIL&quot;],&quot;id&quot;:1,&quot;size&quot;:50,&quot;pers_id&quot;: 081945}', '{&quot;datasour ... (1200 characters truncated) ... 081945}', ' {&quot;path&quot;:[&quot;CATEGORY&quot;,&quot;PERSONAL  &quot;,&quot;EMAIL&quot;,&quot;PERSONAL  _MAIL&quot;,&quot;ADMIN&quot;],&quot;id&quot;:1,&quot;size&quot;:1,&quot;pers_id&quot;: 081945} ']]}]</p>
  <p>not able to pass parameter to array field(in procedures)</p>