topic Re: Is there a way to submit multiple queries to data bricks SQL END POINT using REST API ? in Data Engineering

Is there a way to submit multiple queries to data bricks SQL END POINT using REST API ?

Manoj — Thu, 28 Oct 2021 22:17:27 GMT

Is there a way to submit multiple queries to data bricks SQL END POINT using REST API ?

Re: Is there a way to submit multiple queries to data bricks SQL END POINT using REST API ?

Piper_Wilson — Fri, 29 Oct 2021 03:03:27 GMT

Hello, @Manoj Kumar Rayalla - My name is Piper and I'm one of the moderators for Databricks. Welcome and thank you for your question. Let's give it a bit longer to see what the community has to say. Otherwise, we'll circle back around.

Re: Is there a way to submit multiple queries to data bricks SQL END POINT using REST API ?

BilalAslamDbrx — Fri, 29 Oct 2021 13:39:01 GMT

Hi @Manoj Kumar Rayalla -- not yet. We currently support ODBC/JDBC but are looking into a SQL API. If you're interested please contact me at bilal dot aslam at databricks dot com and tell me what you're trying to do. I'll be happy to help!

Re: Is there a way to submit multiple queries to data bricks SQL END POINT using REST API ?

Manoj — Mon, 01 Nov 2021 12:39:11 GMT

Sorry @Piper Wilson @Bilal Aslam , Sorry for not being complete, I am trying to submit 30 queries at a time to see the performance of SQL End Point, Accordingly i would have to plan for the size of it.

Re: Is there a way to submit multiple queries to data bricks SQL END POINT using REST API ?

BilalAslamDbrx — Wed, 03 Nov 2021 13:48:48 GMT

@Manoj Kumar Rayalla DBSQL currently limits execution to 10 concurrent queries per cluster so there could be some queuing with 30 concurrent queries. You may want to turn on multi-cluster load balancing to horizontally scale with 1 more cluster for this level of concurrency.