title: Execution of SQL Statements inside Stored Procedure in Parallel in SnowFlake DB
body: <p>In SnowFlake, would there be any option to execute the sql statements in parallel inside a Stored Procedure. I've a Stored Procedure (shown below), which has 35 sql statements, which run sequentially.  We are planning to reduce the time , thinking of executing all these in parallel.</p>
  <p>What would be the best approach to achieve this? (All I could think of is create 35 Stored Procedures and call all of them from a scheduler same time). Wanted to check if there would be any better approach of any SnowFlake feature to achieve this?</p>
  <pre><code>create or replace procedure SP_TEST()
    returns string
    language javascript
    execute as CALLER
    as
    $$
      try {
        var step_num = 0
      step_num = 0
      step_num++ //--#1
         var sql_statement1   = snowflake.createStatement( {sqlText: `INSERT INTO TGT_TBL select * from TBL_A`} )
         var sql_statement1_execute = sql_statement1.execute() 
          step_num++ //--#1
        var sql_statement2   = snowflake.createStatement( {sqlText: `INSERT INTO TGT_TBL select * from TBL_B`} )
        var sql_statement2_execute = sql_statement2.execute() 
        return  &quot;Completed &quot;+step_num+&quot; steps to load into TGT_TBL&quot;
       }
     catch (err) {
          throw(err)
      }
    $$
  ;
  </code></pre>