Forum Discussion

keataunooi's avatar
keataunooi
Regular Visitor
2 years ago
Solved

How to set default Lakehouse in the notebook programmatically?

Hi All,   Here are my workspace setup:   Workspace Fabric's Artifacts Git branch folder Fabric-Sandbox notebook: landingtoBronze lakehouse: Bronze feature/bronze123 Fabric-Dev ...
data engineering
one lake
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi keataunooi 
    Thanks for using Fabric Community.
    To programmatically attach a lakehouse for a session level, you can use this below code in your notebook:

    # Welcome to your new notebook
# Type here in the cell editor to add code!
%%configure
{
    "defaultLakehouse": {  # This overwrites the default lakehouse for current session
        "name": "your-lakehouse-name",
        #"id": "<(optional) lakehouse-id>",
        #"workspaceId": "<(optional) workspace-id-that-contains-the-lakehouse>" # Add workspace ID if it's from another workspace
    }
}


    Hope this helps. Please let me know if you have any further questions.

gori137's avatar
gori137
Regular Visitor
2 years ago

Thanks for an excelent question. I can't use the %%configure command.
The error message is :
UsageError: Line magic function '%%configure' not found.

PunChili's avatar
PunChili
Advocate II
2 years ago

Same for me. Is there missing a library? Isn't this magic part of sparkmagic? When use %pip install to install sparkmagic, an error is occurring "ERROR: Could not build wheels for gssapi, krb5, which is required to install pyproject.toml-based projects"...