cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Azure Databricks SQL Warehouse connection issue

Yuliya
New Contributor II

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.

2 REPLIES 2

Rostislaw
New Contributor III

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).

jose_gonzalez
Moderator
Moderator

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.