Forum Discussion

chetanhiwale's avatar
chetanhiwale
Resolver I
1 year ago
Solved

Unable to create sql endpoint for lakehouse

I am trying to create a lakehouse in Fabric, but not able to create sql endpoint and semantic model. Do we need to enable some thing first before creating lakehouse

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi chetanhiwale 

     

    Please open the lakehouse you have created. This will bring you to the Lakehouse Explorer page. If it displays a message bar like "Unable to create the SQL analytics endpoint." with a Retry button, just click the "Retry" button. 

     

    Reference:  SQL analytics endpoint reprovisioning

    SQL analytics endpoint reprovisioning

    We offer the ability to retry SQL analytics endpoint provisioning directly within a lakehouse. Therefore if your initial provisioning attempt fails, you have the option to try again without the need to create an entirely new lakehouse. This feature empowers you to self-mitigate provisioning issues in convenient way in the UI avoiding the need for complete lakehouse re-creation.

     

    Best Regards,
    Jing
    Community Support Team

3 Replies

  • Basically whenever you create a lakehouse, the SQL endpoint and Semantic model gets created automatically.

    Can you confirm whether the lakehouse was created within your workspace?
    If yes, can you share the screenshot for the same

    • chetanhiwale's avatar
      chetanhiwale
      Resolver I

      here is a screenshot, where t1 is a lakehouse, But sqlendpoint  and semantic model is not generated. 

       

      I also have admin permissions for the workspace

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi chetanhiwale 

         

        Please open the lakehouse you have created. This will bring you to the Lakehouse Explorer page. If it displays a message bar like "Unable to create the SQL analytics endpoint." with a Retry button, just click the "Retry" button. 

         

        Reference:  SQL analytics endpoint reprovisioning

        SQL analytics endpoint reprovisioning

        We offer the ability to retry SQL analytics endpoint provisioning directly within a lakehouse. Therefore if your initial provisioning attempt fails, you have the option to try again without the need to create an entirely new lakehouse. This feature empowers you to self-mitigate provisioning issues in convenient way in the UI avoiding the need for complete lakehouse re-creation.

         

        Best Regards,
        Jing
        Community Support Team