Forum Discussion

chetanhiwale's avatar
chetanhiwale
Icon for Resolver I rankResolver 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
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

NandanHegde's avatar
NandanHegde
Icon for Super User rankSuper User
1 year ago

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
    Icon for Resolver I rankResolver I
    1 year ago

    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
      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