Azure Databricks SQL Warehouse connection issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2022 07:29 PM
When trying to start SQL Warehouse from my Azure pay-as-you-go subscription, I'm getting error about not enough vCPUs provisioned. Documentation says to increase quota at Azure portal - but it requires knowing type of vCPUs to provision. What type of CPUs should be provisioned? Is it EDSv4 family, or spot instances, or something else? What is the best way to see what clusters each t-shirt size of SQL Warehouse is using? Thank you.
- Labels:
-
Azure
-
Databricks SQL Warehouse
-
DBSQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-15-2022 12:20 PM
it is documented here: https://docs.microsoft.com/en-us/azure/databricks/sql/admin/sql-endpoints#sql-endpoints-name-changed...
With 2X-Small size you allocate 1x Standard_E8ds_v4 for driver and 1x Standard_E8ds_v4 for worker.
When configuring a SQL warehouse you can chose between reliability optimized (=full price VMs) and cost optimized (=spot VMs for workers).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2022 08:40 AM
Hi @Yuliya Quintela,
Just a friendly follow-up. Did Rostislaw's response help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.