Databricks JDBC driver multi query in one request.

[shkelzeen]

Can I run multi query in one command using databricks JDBC driver and would databricks execute one query faster then running multi queries in one script?  

[shkelzeen]

Hi Kaniz

Thank you for you reply. I did mean the jdbc driver for external table I mean the jdbc driver which is used to connect to databricks, is there any property I can send on the JDBC connection to databricks from my service which will allow multipart query run in the same command.

[NandiniN]

Yes, you can run multiple queries in one command using the Databricks JDBC driver.The results will be displayed in separate tables.

When you run the multiple queries, they are all still individual queries. Running multiple queries in a script will not slow down the queries response time.

If you are using a notebook for readability and debugging purposes having them in separate cells would be nice, but if you are calling a script, they can be written in the sequential order, and they would run sequentially.

[pparwale]

Can someone please provide a sample code to run multiple queries at once using jdbc.