topic Re: Unable to create SQL warehouse in Warehousing & Analytics

Unable to create SQL warehouse

rnai369 — Mon, 25 Aug 2025 11:52:33 GMT

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,

Re: Unable to create SQL warehouse

BS_THE_ANALYST — Mon, 25 Aug 2025 12:04:28 GMT

@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

Re: Unable to create SQL warehouse

Coffee77 — Mon, 25 Aug 2025 12:10:22 GMT

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.

Re: Unable to create SQL warehouse

rnai369 — Mon, 25 Aug 2025 12:19:35 GMT

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,

Re: Unable to create SQL warehouse

szymon_dybczak — Mon, 25 Aug 2025 12:25:07 GMT

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

Re: Unable to create SQL warehouse

Coffee77 — Mon, 25 Aug 2025 12:42:17 GMT

With free edition you have that limitation indeed 🔥

Re: Unable to create SQL warehouse

rnai369 — Tue, 26 Aug 2025 11:04:32 GMT

Thanks to all for your support.