topic Re: Databricks JDBC driver multi query in one request. in Get Started Discussions

Databricks JDBC driver multi query in one request.

shkelzeen — Mon, 18 Dec 2023 12:28:53 GMT

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?

Re: Databricks JDBC driver multi query in one request.

shkelzeen — Tue, 19 Dec 2023 08:47:57 GMT

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.

Re: Databricks JDBC driver multi query in one request.

NandiniN — Wed, 01 Jan 2025 05:55:14 GMT

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.

Re: Databricks JDBC driver multi query in one request.

pparwale — Fri, 28 Feb 2025 21:47:06 GMT

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