Pass notebook running day and time to notebook

[NEK]

Hello Expert,

I have a use case where I need to run a notebook within my pipeline every day and pass the running day and time parameters to notebook. 

What is the best way to achieve this?

[NEK]

Thanks AndyDDC

[v-cboorla-msft]

Hi @NEK 

Thanks for using Microsoft Fabric Community and posting your ask here.

Just wanted to check whether your issue got resolved. Continue using Fabric Community for help regarding your queries.

Thanks

[AndyDDC · Accepted solution]

Hi, you can create a parameter cell in the Notebook Spark compute for Data Engineering and Data Science - Microsoft Fabric | Microsoft Learn and then in the Notebook activity, add a parameter to the "Base Parameters" section.  You can then use the pipeline expression language to create a current datetime (or pass in any other value you need).

[NEK]

Thank you AndyDDC. What is the way automatically run the notebook every day or some days of the week. Do we need to use something like schedule trigger?

[AndyDDC]

You can either schedule the data pipeline that runs the notebook activity https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-runs#scheduled-data-pipeline-runs

or schedule the notebook itself by clicking Run then Schedule in the notebook editor.

[AndyDDC]

Hi @NEK if this has been of help would you please mark my reply as the solution to close this off. Thank you