Forum Discussion

Roj_03an's avatar
Roj_03an
New Member
18 days ago

Fabric Lakehouse

I created a schema in lakehouse but it is not reflecting in same lakehouse sql endpoint

6 Replies

  • v-aatheeque's avatar
    v-aatheeque
    Community Support

    Hi Roj_03an​ 

    Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

  • ipkus's avatar
    ipkus
    Frequent Visitor

    One additional thing you may want to check is whether you’re using any shortcuts in the Lakehouse and, if so, whether there are any errors. You can verify this by switching to SQL Endpoint mode. If you see any shortcut-related errors, those will need to be resolved first before the tables and schemas appear correctly in the SQL Endpoint view.

  • v-aatheeque's avatar
    v-aatheeque
    Community Support

    Hi Roj_03an​ 

    Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

  • kilianbs's avatar
    kilianbs
    Regular Visitor

    It looks like the SQL endpoint hasn't been refreshed, which is why the schema you created isn't showing up.

    Try refreshing the Lakehouse SQL endpoint using this button to see if it appears

     

  • Hi Roj_03an​ 

    Can you also confirm that when you created the lake house, you enabled the option to enable lake house schema as shown as the image below. If you did not do it this way, that might be why it is not showing up on the sequel endpoint.

     

  • Hello Roj_03an​,

    Have you tried refreshing the SQL analytics endpoint, once you have built the schema?

    You should see the schema after the Lakehouse metadata are synchronized. If it is still not there you should check the metadata sync first.

    https://learn.microsoft.com/en-us/fabric/data-engineering/sql-analytics-endpoint-metadata-sync/