Using parameters in Azure Data Factory Data Mapping Activity

Question

I am using a 'mapping data flow' activity in ADF to extract and load some records. I have created 2 parameters in the data flow activity - table_name, schema_name - which I'm trying to use to make the same activity work for multiple tables.

In the Source Options tab on Source(within data flow activity) I have the following query -

select * from '{$SchemaName}'.'{$TableName}'

I'm getting the following error message when I debug -

{
  "message": "Job failed due to reason: at Source 'source1'(Line 2/Col 11): Column operands are not allowed in literal expressions. Details:at Source 'source1'(Line 2/Col 11): Column operands are not allowed in literal expressions",
  "failureType": "UserError",
  "target": "GetLatestData",
  "errorCode": "DFExecutorUserError"
}

Anyone have any thoughts on what I'm doing wrong?

Would you mind copy/paste the data flow script for this data flow? Go to the ADF data flow designer and click the Script button. — Mark Kromer MSFT
– Mark Kromer MSFT, Commented Oct 15, 2020 at 1:17

Dharman · Accepted Answer · 2020-10-15 01:48:37Z

1

Please try this expression:

"select * from {$SchemaName}.{$TableName}"

My test:

1.create two parameters:

2.click 'Add dynamic content [Alt+P]'

3.type this expression: "select * from {$SchemaName}.{$TableName}"

Data preview:

edited Oct 15, 2020 at 1:48

Dharman♦

33.9k27 gold badges105 silver badges157 bronze badges

answered Oct 15, 2020 at 1:43

Steve Johnson

8,8081 gold badge11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Steve Johnson Over a year ago

If you think my answer helps you, you could mark it as answer. Thanks a lot.

Dimeji Olayinka Over a year ago

This does NOT work. I tried the same with my use case "SELECT * FROM PharmacyMaster WHERE NationalProviderIdentifier in ({$parameter1})" and it does not work.

Collectives™ on Stack Overflow

Using parameters in Azure Data Factory Data Mapping Activity

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related