Parameters in Fabric Notebooks

[venkatasuresh_g]

Hi, I have a question regarding our use of three workspaces - DEV, UAT, and PRD. Each workspace has multiple lakes in them. When developers created delta tables using notebooks, they used the table path from the lake, which included the group ID and Lake ID. This worked smoothly in DEV, but when I moved them to the UAT workspace using deployment pipelines, the notebooks still pointed to the DEV workspace lake path. Now, I am trying to figure out how to address this issue. I am considering parameterizing the Workspace ID and Lake IDs, or perhaps there is another method I should be using. Notebooks reach tables or files in data frames for processing, and that is where I see the issue.

Thank you, Suresh

[v-jialongy-msft · Accepted solution]

Hi @venkatasuresh_g 

Based on your description, parameterizing the Workspace ID and Lake IDs in your notebooks is indeed a solid approach to address the issue you're facing.Here's a concise action plan to implement parameterization in your notebooks:

1. Designate a Parameters Cell: First, designate a cell in your notebook as the parameters cell. This is where you'll define the parameters that can be dynamically passed at runtime. For more details on how to designate a parameters cell, please refer to the Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn .
   
   

2. Parameterize Session Configuration: Use the magic command to parameterize your session configuration, including the Workspace ID and Lake IDs. You can find an example and more details in the Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn.
   
   

3. Assign Parameter Values from a Pipeline: When executing the notebook from a pipeline, assign the appropriate Workspace ID and Lake IDs as parameter values. This ensures that the notebook uses the correct paths based on the environment it's being executed in. For guidance on how to assign parameter values from a pipeline, please see the Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[venkatasuresh_g]

Thank you for your response, @v-jialongy-msft. I will implement your guidance and update you on how it goes.

Best regards, Suresh.