topic Re: Cluster SQL Warehouse fails to Start. in Data Engineering

Cluster SQL Warehouse fails to Start.

lasribeiro_univ — Fri, 09 Jun 2023 12:51:47 GMT

I'm a new user of Databricks and I'm taking the Academy course, but I'm having difficulty starting a SQL Warehouse cluster. I've tried several different configurations, but I always get the same error:

Clusters are failing to launch. Cluster launch will be retried.
Details for the latest failure: Error: Error code: ResourceCountExceedsLimitDueToTemplate, error message: Subscription 6a6085f7-891d-4c37-8346-f172e7597a40 has a quota of 3 for resources of type PublicIpAddress with sku SkuNotSpecified. Subscription currently has 0 resources and the template contains 4 new resources of this type which exceeds the quota. Please contact support to increase the quota for resource type PublicIpAddress Type: CLIENT_ERROR Code: AZURE_QUOTA_EXCEEDED_EXCEPTION Cluster-id (internal): 0609-124126-kv5zsnuw Additional details: {"azure_error_code":"ResourceCountExceedsLimitDueToTemplate","azure_error_message":"Subscription 6a6085f7-891d-4c37-8346-f172e7597a40 has a quota of 3 for resources of type PublicIpAddress with sku SkuNotSpecified. Subscription currently has 0 resources and the template contains 4 new resources of this type which exceeds the quota. Please contact support to increase the quota for resource type PublicIpAddress"}

Re: Cluster SQL Warehouse fails to Start.

-werners- — Fri, 09 Jun 2023 12:57:21 GMT

AZURE_QUOTA_EXCEEDED_EXCEPTION can mean 2 things:

you use Community Edition (and Databricks SQL is not available on that edition)

your CPU quota is exceeded on Azure, meaning you have to increase the number of available CPUs (with a change request).

My guess is it is number one.

Re: Cluster SQL Warehouse fails to Start.

lasribeiro_univ — Fri, 09 Jun 2023 14:40:03 GMT

In Azure, I created a new resource group in the "EAST US" region, and as a result, I was able to create a "Serverless" SQL Warehouse in Databricks. This way, I didn't encounter the error mentioned in the initial topic.

Re: Cluster SQL Warehouse fails to Start.

Anonymous — Wed, 14 Jun 2023 06:00:56 GMT

Hi @Luiz Ribeiro

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!