In v20 and before you can define multiple statements in a query tool window. This can be handy when doing comparisons or dealing with wide tables. v20 statement 1 v20 statement 2 In v21 the second statement is simply ignored for SQL DWH instances and results in an error in Snowflake:v21 SQLv21 Snowflake ; separating statements Was this taken out of v21 or should this actually work like in v20?

Solved

Should multiple SQL statements be possible in the query tool?

Userlevel 5

+7

In v20 and before you can define multiple statements in a query tool window. This can be handy when doing comparisons or dealing with wide tables.

In v21 the second statement is simply ignored for SQL DWH instances and results in an error in Snowflake:

Was this taken out of v21 or should this actually work like in v20?

icon

Best answer by Thomas Lind 13 December 2023, 10:25

Userlevel 6

+5

Hi @rory.smith

It was not applied during the creation of the new SaaS release, but it seems like they plan on maybe adding it in a later release.