Forum Discussion

Binit17's avatar
Binit17
Regular Visitor
2 years ago

While configuring notebook session from datafactory pipeline, pipeline notebook activity fails

I am following the fabric documentation to configure lakehouse on notebook from pipeline but getting error Configuration should be valid json object. I see an escape character has been added to the p...
pipelines
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Binit17 ,

Thanks for using Fabric Community.
It looks like issue is with the child nodes and for defaultLakehouse is name, id and workspaceId.
You cannot use parameter name and defaultvalue along with defaultLakehouse.

I would like to understand what you are trying to achieve? So that I can guide you better.


For example -

%%configure  

{ 
    "driverCores": 
    { 
        "parameterName": "driverCoresFromNotebookActivity", 
        "defaultValue": 4 
    }
}

 
Docs to refer - Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn

Hope this is helpful. Please let me know incase of further queries.

Binit17's avatar
Binit17
Regular Visitor
2 years ago

Hi Anonymous , 


I saw in the fabric documentation that these configurations can be passed from the pipeline to the notebooks. I have a situation where i have multiple lakehouse in a workspace and i want to execute a notebook to create tables in different lakehouse from a single notebook. For this i want to pass the lakehouse as a parameter from pipeline to notebook so it sets the default lakehouse as per input parameter and create tables in appropriate lakehouses. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello Binit17 

    Apologies for the delay in reply from our side.


    You can follow below step inorder to pass them as pipeline parameters -

    In Pipeline:


    In Notebook:

     

    %%configure  

{ 
    "defaultLakehouse": {  // This overwrites the default lakehouse for current session
        "name": {
      "parameterName": "paramterName",
      "defaultValue": "gopi_lake_house_1"
        } ,
        "id": {
      "parameterName": "parameterId",
      "defaultValue": "7b6de"
        } 
    }
}


    Output -


    Hope this is helpful. Please let me know incase of further queries.



    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello Binit17 ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
      Otherwise, will respond back with the more details and we will try to help .

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Binit17 ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
        Otherwise, will respond back with the more details and we will try to help .