Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 604
Chicken Sandwich No Pickles Avatar asked Oct 22 '25 23:10

Chicken Sandwich No Pickles


1 Answers

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.

like image 142
Ashok Guntupalli Avatar answered Oct 24 '25 15:10

Ashok Guntupalli



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!