How to Pass Parameters from Notebooks to Pipelines in Microsoft Fabric!

[@ajoy1203]

Hi how can we pass the specific environment to a notebook dynamically in fabric

[@javokhirilkhamboyev4092]

How to use this parameter when we want to use delete statement instead of insert?

[@MathiasDenzin]

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.

[@paulshackleton3594]

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

[@augbir]

Great video Bradley! Are you coming to the European Fabric Community Conference?

[@OneNI83]

Nice.What are the use cases of this ?

[@Tales-from-the-Field]

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

[@sacnan]

how to pass the value of a fabric pipeline variable to a variable in Notebook ?

[@Tales-from-the-Field]

Hi @sacnan We produced a video on that! kzbin.info/www/bejne/iJ7JaGCNhMiiq6c We also cover it in this video when we pass the set variable to the second notebook. Hope this helps!

[@sacnan]

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.