cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
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
Databricks Employee
Databricks Employee

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group