sqlsnowflake-cloud-data-platform

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

Solution

  • 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.