topic Azure Databricks SQL Warehouse connection issue in Data Engineering

Azure Databricks SQL Warehouse connection issue

Yuliya — Wed, 14 Sep 2022 02:29:42 GMT

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.

Re: Azure Databricks SQL Warehouse connection issue

Rostislaw — Thu, 15 Sep 2022 19:20:19 GMT

it is documented here: https://docs.microsoft.com/en-us/azure/databricks/sql/admin/sql-endpoints#sql-endpoints-name-changed-to-sql-warehouses

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

Re: Azure Databricks SQL Warehouse connection issue

jose_gonzalez — Tue, 27 Sep 2022 15:40:43 GMT

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.