Unable to create SQL warehouse

[rnai369]

Hi All,

I am getting below message when hovering on the Create SQL warehouse. I can only see the Serverless Starter Warehouse compute.

You have reached the maximum number of SQL warehouses. Delete an existing warehouse to create new one.

Regards,

RN

[BS_THE_ANALYST · Accepted solution]

@rnai369 are you using the databricks free edition? Or are there policies where you can only create so many in your company?

The fact remains that you are constrained to a limited number in your situation. It's suggesting if you want to create a new one, you can delete an existing one (to free up the capacity). However, if you're looking for a different configuration for the warehouse, you can edit existing ones i.e. enabling/disabling unity catalog. 

@rnai369 Out of interest, how comes you want a new warehouse? 

You can have "Serverless SQL Warehouses" https://learn.microsoft.com/en-us/azure/databricks/admin/sql/serverless I'd probably advise using Serverless anyhow. 

All the best,
BS

[Coffee77 · Accepted solution]

Are you creating a classic SQL Warehouse or a serverless SQL Warehouse? Depending on type quottas are different. I guess you're creating a serverless one as quotta for classic is about 1000 servers per workspace if I remember correctly. So, serverless warehouses are governed by compute quotas, measured in Databricks Units (DBUs) per hour, and enforced at the regional level across all workspaces in your account. You should get this quotta and contact Databricks support if you need to increase it. I hope it helps.

[rnai369 · Accepted solution]

Hi @BS_THE_ANALYST/@Coffee77, I am using the Databricks free edition and getting this message, and I want to explore the 'Create New SQL Warehouse'/ classic SQL Warehouse option.

Regards,

RN

[szymon_dybczak · Accepted solution]

Hi @rnai369 ,

This is a limitation of Free Edition. You can use only serverless compute and has access to a warehouse that is already created for you. You cannot create additional or new ones. 

Databricks Free Edition limitations | Databricks on AWS

If you need to experiment try to use Free Trial - you can use premium feature for 14 days for free

[Coffee77 · Accepted solution]

With free edition you have that limitation indeed 🔥

[rnai369]

Thanks to all for your support.