Scott_Powell1's avatar
Scott_Powell1
New Member
1 year ago
Status:
Needs Votes

Allow dynamic content in Activity Name (and other fields on general tab)

We copy a large number of tables by iterating through a ForEach activity and calling the copy activity for each. When trying to answer "which tables take a long time to copy", it's hard because all of the copy activities just have the generic activity name. If I were able to include dynamic content in the Activity name field, I could use code like @concat('Copy activity - ', Item().TableName) and then in the output we could tell which table was being copied without having to dive into the .json input and output.

 

This would also be helpful for other fields on the general tab - like Timeout settings and the like. Then timeout durations could be calculated offline, and fed into the activity vs. hardcoding. That way if the job starts running slower over time, the timeout setting could be gradually increased.

 

p.s. Unable to use the new "Copy Job" activity because it doesn't support dynamic partitioning, needed for good performance.

 

Thanks,

Scott

3 Comments

  • Azure data factory has something similar with User Properties. We add the current for each value to the Copy Data activity. This then shows up in the Activity Runs detail next to each Copy Data iteration. Having something like this in Fabric would be really helpful!
  • toyama's avatar
    toyama
    Regular Visitor

    I strongly agree! This functionality would be incredibly beneficial for other activities such as Lookup as well. I highly request that this capability be supported across all activity types, just like the Copy activity.

Recent ideas