Search code examples
sqlbatch-processingsnowflake-cloud-data-platform

Snowflake - Run Queries Separately

In SSMS, if I want to run multiple queries in different batches, I put the reserved word GO between each batch.

Is there a way to do this in Snowflake?

Edit #1

Example:

In SSMS, if I were to run the following, I could see all of the results one after another if I was profiling the data.

Select top 5 *
from table_a;
---
Select top 5 *
from table_b;
---
select top 5 *
from table_c;

The results would look like this in the results at the bottom of my screen:

columns
5 rows

columns
5 rows

columns
5 rows

This is what I want to do in Snowflake.

I am running this from the Microsoft Edge browser.

Solution

  • As of today, either using the classic Web Interface or the new Snowsight, when multiple queries are run together, the results window only returns the last result-set.