Blog Post

Azure Data Factory Blog
2 MIN READ

Execute SQL statements using the new 'Script' activity in Azure Data Factory and Synapse Pipelines

Abhishek Narain's avatar
Abhishek Narain
Icon for Microsoft rankMicrosoft
Mar 02, 2022
We are introducing a Script activity in pipelines that provide the ability to execute single or multiple SQL statements.       Using the script activity, you can execute common operation...
Updated Mar 02, 2022
Version 3.0
azure data factory
Azure Data Integration
Big Data Analytics
kristofferabs's avatar
kristofferabs
Copper Contributor
Mar 16, 2022

Using pipeline parameters and variables instead of script parameters works for me. 

 

Using dynamic content you can reference parameters and variables inside @{ reference / expression }.

 

Example of dynamic content:

Select * from [@{pipeline.parameter.schema}].[@{pipeline.parameter.table}]

 

JoshWU