Thanks! This solves one of many problems I have right now. Also good to know, if you pass a boolean from a notebook you can not use True and False, but 1 and 0. In the Pipeline variables it will be set as true and false then.
Hi @oneNI83 per Bradley, "I work with a lot of different customers and we've also received questions about this on other videos. The use case would be if you had a value you were retrieving in a notebook and you wanted to utilize it some where else. How would you do this? The answer: you use the exitValue to pass the value out of the notebook. I then passed this to another notebook and wrote it to a table. You could also use this as an expression for a file path, or to use in an if else condition, or to supply a value to a stored procedure that you want to execute a script task against. There are a lot of different use cases for needing to get this data out of a Notebook and then using it in a data pipeline. "
Hi @sacnan We produced a video on that! th-cam.com/video/Rmf7-WOcouE/w-d-xo.html We also cover it in this video when we pass the set variable to the second notebook. Hope this helps!
Thank you very much for the response . In my use case the item value of the for each activity has to be sent to an variable declared in the notebook. So setting a base parameter is not an option.
Thanks! This solves one of many problems I have right now. Also good to know, if you pass a boolean from a notebook you can not use True and False, but 1 and 0. In the Pipeline variables it will be set as true and false then.
How to use this parameter when we want to use delete statement instead of insert?
hi , how can i update the parameter using sparksql in the notebook with (for example) a select statement e.g. the number if rows added to a table
Hi how can we pass the specific environment to a notebook dynamically in fabric
Great video Bradley! Are you coming to the European Fabric Community Conference?
Nice.What are the use cases of this ?
Hi @oneNI83 per Bradley, "I work with a lot of different customers and we've also received questions about this on other videos. The use case would be if you had a value you were retrieving in a notebook and you wanted to utilize it some where else. How would you do this? The answer: you use the exitValue to pass the value out of the notebook. I then passed this to another notebook and wrote it to a table. You could also use this as an expression for a file path, or to use in an if else condition, or to supply a value to a stored procedure that you want to execute a script task against. There are a lot of different use cases for needing to get this data out of a Notebook and then using it in a data pipeline. "
how to pass the value of a fabric pipeline variable to a variable in Notebook ?
Hi @sacnan We produced a video on that! th-cam.com/video/Rmf7-WOcouE/w-d-xo.html
We also cover it in this video when we pass the set variable to the second notebook. Hope this helps!
Thank you very much for the response .
In my use case the item value of the for each activity has to be sent to an variable declared in the notebook. So setting a base parameter is not an option.