Synapse Notebook - dynamic name

Ryan Abbey 1,161 Reputation points
2021-06-24T23:51:56.903+00:00

Surely there must be an answer to this! I want to be able to have a configuration process that decides which notebook should be called in any particular instance - a similar process for configuring ingestion of files - but the notebook entry is not dynamic in that you have to explicitly state what notebook to run, anyone figured out how to set a notebook dynamically?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,253 questions
{count} votes

Accepted answer
  1. Ruixin Xu 86 Reputation points Microsoft Employee
    2021-06-29T13:23:25.28+00:00

    This is on the radar of Synapse Notebook team. We are going to start work on it since July. No ETA when it will be available on all regions yet.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Samara Soucy - MSFT 5,051 Reputation points
    2021-06-29T05:26:28.657+00:00

    There are two ways that you could implement this, though neither is setting a dynamic notebook name.

    One is to use if/then or switch conditionals in the pipeline to determine which notebook to run:

    110121-2021-06-29-01-21-08-analyticssynapsews-azure-synap.png

    The second would be to create a notebook that handles the dynamic logic and calls the specific notebook needed in the pipeline run. Specifically, using `%run {notebook name} copies the contents of the other notebook copies everything from the referenced notebook into the one called by your pipeline and runs it as if it was part of the one in your pipeline. Any input parameters and output data are available to you.