Forum Discussion
Unable to Provision SQL Analytics Endpoint or Retry for Lakehouse
Hi @KritikaSingh,
The SQL analytics endpoint should normally be created automatically when a Lakehouse is created.
If the endpoint is stuck in provisioning and the Retry option also fails, I would treat this as a provisioning/backend issue rather than a normal configuration issue.
Microsoft documents that every Lakehouse has its own SQL analytics endpoint, and the platform is responsible for keeping the endpoint metadata in sync with the Lakehouse.
Reference:
SQL analytics endpoint metadata sync
A few things I would try:
- Create a new test Lakehouse in the same workspace and check whether the SQL endpoint provisions.
- Create a new test Lakehouse in another workspace on the same capacity.
- Check the Fabric support / known issues page to see whether there is an active issue in your region or capacity.
- If only this Lakehouse is affected, recreate the Lakehouse if it is still empty or early in development.
- If issue still persist, raise a Microsoft support ticket.
Known issues page:
Microsoft Fabric known issues
There is also a similar community thread where the SQL analytics endpoint did not provision and retry did not resolve the issue. The accepted recommendation was to recreate the Lakehouse, and if the issue persists, raise a Microsoft support ticket with the error details and correlation IDs.
Similar thread:
Unable to Provision SQL Analytics Endpoint or Retry for Lakehouse or Warehouse
When raising the ticket, include the workspace name, Lakehouse name, capacity, region, timestamp, error message, and any correlation/request ID from the failed provisioning attempt. Here is the link for raising a support ticket: https://support.fabric.microsoft.com/en-IN/support/
Best regards,
Solutions Architect · Microsoft Fabric Specialist · Parchitect
💡Did my response help you? Clicking Kudos is a small gesture that goes a long way, it encourages contributors and helps the community thrive!
✔️Did I answer your question? Please mark my post as a Solution, it helps others find the answer faster.
- KritikaSingh1 month agoFrequent Visitor
Hi Parchitect ,
I had tried all the ways to fix the issue but nothing worked.
Also to note, some lakehouses created in this workspace have sql endpoints created automatically, while some failed with the mentioned error.
I have now raised case with Microsoft Support Team. Hope to have some resolution soon.
Thanks & Regards,
Kritika Singh