Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
@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.
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.
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!
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.
@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.
Join Us as a Local Community Builder!
Passionate about hosting events and connecting people? Help us grow a vibrant local communityโsign up today to get started!