Forum Discussion

Ka13's avatar
Ka13
Helper II
6 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 values of schema and table output in Notebook.

ExitValue: {"parent1": {"name": "test", "Details": {"status": "active", "schema": "dbo","table" : "employee}}}
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

17 Replies

  • v-prasare's avatar
    v-prasare
    Community Support
    6 months ago
    Hi Ka13,
    You can pass the formed SELECT query to the next Copy Activity by exiting the notebook with the query as JSON and referencing it using dynamic content in the Copy Activity source. This method works reliably in Fabric pipelines and is the recommended way to execute dynamic SQL from a notebook
     
    Thanks,
    prashanth
    MS fabric community support
    • Ka13's avatar
      Ka13
      Helper II
      6 months ago

      Thanks Prasare, will test and let you know if any issues.

    • pallavi_r's avatar
      pallavi_r
      Super User
      6 months ago

      Hi Ka13 ,

      The exitvalue returned from mssparkutils.notebook.run() is always a string. We need to first parse into json using function - json.loads to access its element. Please see the below code.

      import json
      parsed = json.loads(exit_value)
      schema = parsed["parent1"]["Details"]["schema"]
      table = parsed["parent1"]["Details"]["table"]

      The above code worked for me. Please see and let me know if it resolves this issue.

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

      Thanks,

      Pallavi_r

       

       

       

      • Ka13's avatar
        Ka13
        Helper II
        6 months ago

        Thanks Pallavi for your reply. 

        Can we pass the above ExitValue from one notebook to another Notebook activity and access the values of schema and table in another Notebook?. Can you please suggest 

  • 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