CODEWITHSUNDEEP
sqlsnowflake-cloud-data-platform
Chicken Sandwich No Pickles
Chicken Sandwich No Pickles

Reputation: 3362

Snowflake - Run Multiple SQL Queries at Once

Let's PRETEND, I am using SQL Server, if I execute the following queries, they will go one after the next:

select top 10 * from table_1;
go
select top 10 * from table_2;
go
select top 10 * from table_3;
go

Snowflake does not have a go command, and it appears to only execute the last statement only.

Is there a way to make all 3 (or whatever my number is) run instead of just the last one running?

Edit #1:

I am using the Snowflake Web UI

Upvotes: 3

Views: 28534

Answers (3)

Ashok Guntupalli
Ashok Guntupalli

Reputation: 61

There is no go command in snowflake. however, you can execute multiple queries at the same time from the WEB UI of the snowflake. Please find the sql below

select top 10 * from table_1;

select top 10 * from table_2;

select top 10 * from table_3;

Select all the above queries and click on execute. Each query will have the query id and result set to view.

Upvotes: 5

Tushar Kathpal
Tushar Kathpal

Reputation: 121

You can make use of SnowSQL and submit use the command below, that will submit the queries asynchronously:

snowsql -o log_level=DEBUG -q "select top 10 * from table_1;> select top 10 * from table_2;> select top 10 * from table_3;"

Upvotes: 0

Jeffrey Jacobs
Jeffrey Jacobs

Reputation: 332

Use a tool like DBVisualizer that lets you run a script and see the results of all the queries executed, each in their own tab.

Upvotes: 1

Related Questions