Forum Discussion

danitskofabric's avatar
danitskofabric
Frequent Visitor
1 year ago
Solved

Fabric Default Schema Lakehouse

So for a Notebook i use this to define the defaultLakehouse: %%configure -f { "defaultLakehouse": { "name": "test" } }   Here "test" is a Lakehouse without activating Lakehouse-Sc...
data engineering
lakehouse
notebook
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi danitskofabric,

     

    Currently %%configure with only the lakehouse name works only when schemas are disabled.
    When schemas are enabled, fabric requires both the lakehouse Id and workspaceId for binding, so fully portable notebooks need to fetch these Id’s dynamically at runtime. As of now there is no way to avoid Id’s completely, it is a current limitation of schema enabled lakehouses.

     

    I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

    Fabric Ideas - Microsoft Fabric Community

     

    Thanks and regards,

    Anjan Kumar Chippa

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

Hi danitskofabric ,

 

I performed two tests.
First, I created a table and then executed the scripts.
Both worked with a schema-enabled lakehouse.

Did you do the same thing?

 

See the Screenshots:

 

 

Best regards

 

  • danitskofabric's avatar
    danitskofabric
    Frequent Visitor
    1 year ago

    Hi spaceman127,

    Thank You for your reply.

    If I manually add the lakehouse it works without any problems, but im trying to bind it via %%configure.