'How to execute multiple asynchronous queries in Snowflake without it's interferring each other?
I would like to execute multiple asynchronous queries. However, it keeps interferring each other SQL commands.
For example, query A need to use schema A and query B need to use schema B but the command to use schema B is triggered then query A is run after it which cause query A to fail.
Sample query A:
- USE SCHEMA TEST;
- SELECT * FROM TABLE_A;
Sample query B:
- USE SCHEMA TEST_2;
- SELECT * FROM TABLE_B;
What happened in my case when triggered both of them asynchronously in the same connection is that it ran like this:
- USE SCHEMA TEST;
- SELECT * FROM TABLE_B;
which cause query to fail because TABLE_B doesn't exists in schema TEST.
Does the snowflake any way to trigger multiple asynchronously queries without it interferring each other? Other than connect, run the query and the disconnect again.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
