Forum Discussion

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

data engineering

notebook

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