search

databricks / sqltools-databricks-driver

SQLTools driver for Databricks SQL
Other
11 stars 3 forks source link

There is no way to run multiple SQL statements #71

Open eperfilyev opened 11 months ago

eperfilyev commented 11 months ago

The query editor fails on the attempt to run multiple statements separated by ";"

Sample code

use catalog datahub_raw;

DROP TABLE accela.app_status_group;
DROP TABLE accela.app_status_grouphistory;
DROP TABLE accela.b1_expiration;

Query fails with the error below.


[PARSE_SYNTAX_ERROR] Syntax error at or near 'DROP': extra input 'DROP'.(line 3, pos 0)

== SQL ==
use catalog datahub_raw;

DROP TABLE accela.app_status_group;
^^^
DROP TABLE accela.app_status_grouphistory;
DROP TABLE accela.b1_expiration;