Data bricks SQL is allowing 10 queries only ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ12-02-2022 12:43 AM
Each endpoint Can have maximum 10 concurrent queries else they are going to be queued.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ12-05-2022 12:31 AM
That's right
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ12-02-2022 04:07 AM
You can only run 10 concurrent queries I think.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ12-02-2022 04:08 AM
You can call notebook from a notebook for nesting and increase concurrency.โ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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.