search

Snowflake-Labs / sqltools-snowflake-driver

A Snowflake driver for the SQLTools VSCode extension.
MIT License
35 stars 15 forks source link

Unable to run scripts with multiple SQL statements #43

Open kjn70 opened 3 years ago

kjn70 commented 3 years ago

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.

pluong5438 commented 3 years ago

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.