Forum Discussion

Ka13's avatar
Ka13
Helper II
7 months ago
Solved

Fabric Notebook ExitValue how to select specific values

Hi,  I had a question in the Fabric Notebook. In Fabric Notebook , From the ExitValue below output in Notebook , how to select specific value , like only schema and table and need to select va...
data engineering
notebook
  • pallavi_r's avatar
    pallavi_r
    6 months ago

    Hi Ka13 ,

    Yes we can read this query in a copy activity. First convert this select query to json 

    import json
    from notebookutils import notebook
    nb_result = {
        "select_query": select_query
    }
    notebook.exit(json.dumps(nb_result))

    Then in pipeline add notebook activity and connect to copy data. In the dynamic content of copy data, add this json expression.

    @json(activity('Notebook1').output.exitValue).select_query

    This works.

    If this post helps, please accept this as a solution. Appreciate your kudos.

    Thanks,

    Pallavi_r

v-prasare's avatar
v-prasare
Community Support
6 months ago

Hi @RajK2,

thanks for explaining the scenario. To better understand the issue and provide an accurate solution, could you please share a small set of sample data (with any sensitive information removed) along with the expected output? This will help ensure the guidance is aligned with your exact requirement.

 

 

Thanks,

Prashanth

MS fabric community support

  • Ka13's avatar
    Ka13
    Helper II
    6 months ago

    Hi Prasare , I tried the below solution provided by Pallavi it worked

     

     

    In Notebook
     
    import json
    from notebookutils import notebook


    nb_result = {
      "select_query" = select_query
    }


    notebook.exit(json.dumps(nb_result))

    Then in pipeline, added notebook activity. In the dynamic content added the json

    Anonymous(activity('Notebook1).output.exitValue).select_query