How can I pass parameters to SQL datasets in ADF mapping data flows at development time?

Richard Swinbank 46 Reputation points
2020-09-20T09:32:45.967+00:00

In my Azure Data Factory, I have an Azure SQL dataset parameterised for table & schema name:

25933-image.png

When I use it as a sink dataset in a mapping dataflow, I can't see any option to supply parameters:

25952-image.png

I supply them at runtime from the calling Data flow activity:

25981-image.png

But working with the dataset at development time is inconvenient. Is there a way to supply parameter values at dev time?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,481 questions
0 comments
Accepted answer
  1. Richard Swinbank 372 Reputation points MVP
    2020-09-22T07:25:42.32+00:00

    I've found the answer -- I can set parameter values in Debug settings (available when the debug cluster is running):

    26249-image.png

    Thanks for looking into this for me.

    5 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HarithaMaddi-MSFT 10,126 Reputation points
    2020-09-21T11:30:07.563+00:00

    Hi @Richard Swinbank ,

    Welcome to Microsoft Q&A Platform. Thanks for posting the query.

    There is a option to pass default values from dataset as shown below. Please suggest if this helps for testing during development time.

    26106-parametersdefaultvalue.png

    Hope this helps! Please let us know for further queries and we will be glad to assist.