Support execute_async to parallelize run-operation in Snowflake

[b-per]

Today, run_query in a run-operation is single-threaded.
With multiple queries to be run, each of them needs to wait for the previous one to return data before being executed.

execute_async allows async queries in Snowflake.

• Would it make sense to support async queries in Snowflake?
  • Would we create a run_query_async() function for that? Or a parameter for run_query(... , async=True) ?
• What changes would be required in dbt-core?
• Is this discussion more suited in the dbt-core repo to have it as a first class dbt support instead of a Snowflake one?