topic Re: Unable start SQL warehouse AWS in Warehousing & Analytics

Unable start SQL warehouse AWS

Testing2 — Tue, 11 Jul 2023 07:03:22 GMT

Unable start SQL warehouse AWS. Warehouse is in starting state for a very long time and error is thrown

Re: Unable start SQL warehouse AWS

Tharun-Kumar — Wed, 12 Jul 2023 04:38:39 GMT

Does this error go away after a certain time or is it consistently showing up the same error message?

If it's transient, The warehouse would have been created from a cold path of compute resources and that is why you are seeing the delayed messages on startup.

Re: Unable start SQL warehouse AWS

Testing2 — Wed, 12 Jul 2023 05:02:19 GMT

It is consistently showing the same message and warehouse has not even started once in the past 2 days

Re: Unable start SQL warehouse AWS

Anonymous — Wed, 12 Jul 2023 08:46:06 GMT

Hi @Testing2

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: Unable start SQL warehouse AWS

Testing2 — Wed, 12 Jul 2023 11:08:01 GMT

Sorry Im still facing the same issue

Re: Unable start SQL warehouse AWS

rdkarthikeyan27 — Wed, 12 Jul 2023 21:04:38 GMT

Can you please check on particular SQL warehouse instances type quota with cloud provider (Azure/AWS) . may be that particular instance type quota is over with your account . Same issue we have faced and requested AWS to increase the quota of that instances and got resolved .

Re: Unable start SQL warehouse AWS

Testing2 — Thu, 13 Jul 2023 08:23:10 GMT

Which specific quota should I be checking?