Share via

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.
11,624 questions
0 comments
Accepted answer
  1. Richard Swinbank 527 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,146 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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.