Forum Discussion

Charline_74's avatar
Charline_74
Resolver I
1 year ago
Solved

Change Default Lakehouse

Hello, In a notebook which is in DEV I use this code to get the ID of the Lakehouse in DEV and the ID of the Workspace DEV : df_Lakehouse = labs.list_lakehouses() lakehouse_row = df_Lakehouses[df_...
data engineering
lakehouse
notebook
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    Hi Charline_74 

    To change the default lakehouse in a Microsoft Fabric notebook, you can use the %%configure magic command with the defaultLakehouse parameter. However, the issue in your code is that you're trying to use Python variables directly within the JSON configuration, which isn't possible. Instead, you need to format the JSON string with the variable values.

     

    could you please give this a try :


    df_Lakehouses = labs.list_lakehouses()
    lakehouse_row = df_Lakehouses[df_Lakehouses["Lakehouse Name"] == "Lakehouse"]
    lakehouse_id = lakehouse_row.iloc[0]["Lakehouse ID"]
    workspace_id = spark.conf.get("trident.workspace.id")

    %%configure -f
    {
    "defaultLakehouse": {
    "name": "Lakehouse",
    "id": "%s",
    "workspaceId": "%s"
    }
    }
    """ % (lakehouse_id, workspace_id)


    Please give kudos and mark this as solution if this helps.

    Thanks

nilendraFabric's avatar
nilendraFabric
Super User
1 year ago

Hi Charline_74 

To change the default lakehouse in a Microsoft Fabric notebook, you can use the %%configure magic command with the defaultLakehouse parameter. However, the issue in your code is that you're trying to use Python variables directly within the JSON configuration, which isn't possible. Instead, you need to format the JSON string with the variable values.

 

could you please give this a try :


df_Lakehouses = labs.list_lakehouses()
lakehouse_row = df_Lakehouses[df_Lakehouses["Lakehouse Name"] == "Lakehouse"]
lakehouse_id = lakehouse_row.iloc[0]["Lakehouse ID"]
workspace_id = spark.conf.get("trident.workspace.id")

%%configure -f
{
"defaultLakehouse": {
"name": "Lakehouse",
"id": "%s",
"workspaceId": "%s"
}
}
""" % (lakehouse_id, workspace_id)


Please give kudos and mark this as solution if this helps.

Thanks

PANDAmonium's avatar
PANDAmonium
Resolver IV
1 year ago

Hi,

 

I'm getting the following error when trying this solution:

Cell In[17], line 14

""" % (lakehouse_id, workspace_id)

^

SyntaxError: incomplete input

 

When moving the configure magic to it's own cell I get this error:

MagicUsageError: Configuration should be a valid JSON object expression.

--> JsonReaderException: After parsing a value an unexpected character was encountered: ". Path 'defaultLakehouse', line 7, position 0.

 

Tried multiple variations of it, but I can't seem to figure it out. Appreciate any help.

 

Thanks!