11-22-2022 08:03 AM
•Power BI is a publisher that uses AD group authentication to publish result sets. Since the publisher's credentials are maintained, the same user can access the data bricks database.
•Number of the users are retrieving the data from the power bi or if any report started from the same user the user SQL's are queuing state.
•The first 10 queries that we looked into were executing concurrently, and once any of the first 10 SQL statements were finished, the 11th query was launched.
11-22-2022 07:00 PM
Hi @Sai Krishna Cheruvu Just give you some info
https://docs.databricks.com/sql/get-started/admin-set-up-user-to-query-table.html
https://docs.databricks.com/sql/get-started/user-quickstart.html
give some info maybe helpful in this case
11-27-2022 08:27 AM
Hi @Sai Krishna Cheruvu
If you haven't configured your warehouse with an autoscale capacity (min clusters = max clusters = 1), you have probably filled the queue with your first 10 queries (See. https://learn.microsoft.com/en-us/azure/databricks/sql/admin/sql-endpoints#queueing-and-autoscaling or the equivalence according your cloud provider).
If those 10 queries are big ones, you should increase your autoscale capacity and depending on these queries' execution profile, Databricks will automatically upscale your warehouse to deliver the expected concurrency level according the algorithm given in the documentation.
HTH
Laurent
12-02-2022 12:43 AM
Each endpoint Can have maximum 10 concurrent queries else they are going to be queued.
12-05-2022 12:31 AM
That's right
12-02-2022 04:07 AM
You can only run 10 concurrent queries I think.
12-02-2022 04:08 AM
You can call notebook from a notebook for nesting and increase concurrency.
12-02-2022 12:26 PM
I believe 10 is a limit as of now. See if you can increase the concurrency limit from the source.
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.