cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Warehouse - several issues

Mohan2
New Contributor

Hi there,

I am facing several issues while trying to run SQL warehouse-starter on Azure databricks.

Please note I am new to this data world, Azure & Databricks .  while starting SQL starter warehouse in Databricks Trail version and  I am getting these errors:

Error 1 

Clusters are failing to launch. Cluster launch will be retried.
Mohan2_0-1695443100723.png

Error -2 After increasing the Quota I get below error by following the Link given in the error message.

Mohan2_0-1695441032770.png

I don't have Virtual VM's setup in Azure . If this causing above issues  please guide me basic configuration for setting VM resources in Azure.

Also suggest if any resources to be setup in Azure to use Data bricks Seamlessly.

Appreciate your support on this.

Regards,

Mohan M

1 REPLY 1

Kaniz
Community Manager
Community Manager

Hi @Mohan2Based on the errors you're encountering, you're having issues with cluster creation and quota limitations.

Here are some potential solutions:

1. **Increase your Azure quota:** The error message indicates that your Azure subscription does not have enough percentage to create the needed resources. You can request a quota increase by contacting Azure Support.

2. **Setup Virtual Machines in Azure:** Since you mentioned you don't have Virtual VMs set up in Azure, you might need to set them up.

Here are the basic steps:
   - Sign in to the Azure portal.
   - In the left-hand menu, click on "Create a resource".
   - In the "New" window, search for "Virtual Machine" and select it.
   - In the "Create a Virtual Machine" window, fill in the necessary details like name, region, image, size, etc., and click "Review + create".
   - Once the validation is passed, click on "Create".

3. **Handle high load and requests:** If your Azure resource provider is under high load and requests are being throttled, you may need to wait and try again later. If this is a frequent issue, consider spreading your workloads across multiple clusters or adjusting the timing of your jobs to avoid peak usage times.

4. **Ensure your Databricks cluster is not overloaded:** If your cluster has too many jobs running, it can overload the cluster and cause timeouts. As a general rule, move heavier data pipelines to run on their own Azure Databricks clusters. 

Remember to continuously monitor your resources and adjust them according to your needs. This will help you use Azure Databricks more seamlessly.