Forum Discussion

venkatasuresh_g's avatar
2 years ago
Solved

Parameters in Fabric Notebooks

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 p...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.