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
    7 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

Ka13's avatar
Ka13
Helper II
7 months ago

Thanks Pallavi, can we pass this select query formed to the next activity ( Copy Activity) ? , to execute the query. Will test the above and let you know if any questions.

Ka13's avatar
Ka13
Helper II
7 months ago

Hi Pallavi, can we pass this formed select query in next Copy Activity?

  • pallavi_r's avatar
    pallavi_r
    Super User
    7 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

  • Ka13's avatar
    Ka13
    Helper II
    7 months ago

    Hi Pallavi,

    in the getcol , the column names are getting split as below . Can you please suggest 

     

    ID - AS I , D AS D

     

     

     

  • pallavi_r's avatar
    pallavi_r
    Super User
    7 months ago

    Hi Ka13 

    Sorry for late reply. Can you please send me the exit value and parsed. 

    exit_value = mssparkutils.notebook.run(
        "nb_first",
        timeout_seconds=60
    )

    exit_value
    and this one
    import json

    parsed = json.loads(exit_value)
    parsed
     
    Thanks,
    Pallavi
  • Ka13's avatar
    Ka13
    Helper II
    6 months ago

    Thanks Pallavi tested above it's working