The warehouse fails to start

[joao_augusto]

Hi, everyone!

Does anyone know the reason for this problem? It says that I do not need to do anything, but if I don't restart the warehouse manually, it will not start.

Is there a way to fix it? Or at least, create monitoring for it? We have some jobs that call the Databricks API with SQL statements, but when the warehouse fails to start, our jobs also fail. It has been really troublesome lately.

For the provider, I'm using AWS.

 

[szymon_dybczak]

Hi @joao_augusto ,

Maybe you're hitting some quotas on AWS EC2 instances? Could you check it?
Regarding monitoring, you can try to use API calls and check health status of you sql warehouses:

List warehouses | SQL Warehouses API | REST API reference | Azure Databricks