Saswati
Reputation: 21
How can I run queries concurrently in Snowflake
How can i run some set a select queries in snowflake concurrently. When i write query and running it it runs one by one, but i want all the query to start at same time..
Can anybody help me on this. Thanks in advance Regards Saswati.
Upvotes: 1
Views: 4069
Answers (1)
Hans Henrik Eriksen
Reputation: 2850
There are multiple ways to do this, some of them are:
- Create a
TASKfor each query and schedule for the same time - Use an external tool (eg ETL tool) capable of running multiple queries in parallel
- Write a script (eg Python) using eg threading
Upvotes: 2
Related Questions
- Snowflake - Run Multiple SQL Queries at Once
- SNOWFLAKE SQL: How to run several select statement in one command
- how are concurrent queries handled in snowflake?
- Execution of SQL Statements inside Stored Procedure in Parallel in SnowFlake DB
- Is there a way to parallelerise the execution of stored procedures in snowflake
- Does snowflake sql api support concurrent users?
- Snowflake - Run Queries Separately
- Executing Multiple Queries in Snowsight
- Asynchronous query execution in Snowflake: SQL execution canceled
- Read rows in batches from snowflake