SNOW-1545867: COPY INTO command doesn't get submitted asynchronously by using collect_nowait

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

3.8

2. What operating system and processor architecture are you using?

Snowpark Snowflake Stored Procedure

3. What are the component versions in the environment (pip freeze)?

Snowpark Snowflake Stored Procedure

4. What did you do?

when submitting copy commands to async jobs.. the copy commands still run in sequence. Whereas other sql's/CTAS does get submitted asynchronously.
for table in table_list:
sql_command -> COPY INTO command
async_job = session.sql(sql_command).collect_nowait()
async_jobs.append(async_job)

5. What did you expect to see?

COPY INTO should be submitted asynchronously and I should see multiple parallel running COPY commands.

6. Can you set logging to DEBUG and collect the logs?

Running within Snowflake