sqltools-snowflake-driver icon indicating copy to clipboard operation
sqltools-snowflake-driver copied to clipboard

Unable to run scripts with multiple SQL statements

Open kjn70 opened this issue 3 years ago • 1 comments

Attempting to run a script with multiple SQL statements, for example:

select 'Hello World' as "Welcome Message";
select 'Hello again!' as "Message 2";

results in the following error:

Multiple SQL Statements in a single API call are not supported; use one API call per statement instead.

This makes the driver effectively useless for many scripted tasks.

kjn70 avatar Apr 19 '21 17:04 kjn70

Same issue. Would be nice to be able to run a file with multiple sql statements using this extension but unfortunately we have to fall back to SnowSQL via terminal.

pluong5438 avatar May 17 '21 17:05 pluong5438