SQL Query using script activity in ADF

Question

I have the script activity in ADF pipeline:

On running this, I see the following error. What does this indicate and how do fix this?

You need to qualify the @variable, otherwise the sql is looking for a temp table. This may help stackoverflow.com/questions/62213623/… — Jon
– Jon, Commented Mar 30, 2022 at 14:44

AnnuKumari · Accepted Answer · 2022-03-31 07:45:29Z

2

You are trying to make tableName dynamic. It won't work like that. Better create a variable and use Set variable activity to set the tableName. Then use the same in your script Activity.

select * from @{variables('tableName')} where id=@id

Set variable activity settings:

Here is the script activity settings:

Output :

answered Mar 31, 2022 at 7:45

AnnuKumari

5832 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

SQL Query using script activity in ADF

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related