Introduction
Azure Data Factory recently introduced a new activity, called the Script activity. We can use the Script activity to execute DML (Data Manipulation Language) statements like SELECT, INSERT, UPDATE, as well as DDL (Data Definition Language) statements like CREATE, ALTER, and DROP operations.
Currently, the Script activity supports the following data stores:
Azure SQL Database Azure Synapse Analytics SQL Server Database Oracle Snowflake
A few example use cases for the Script activity:
Create, alter and drop database objects such as tables, views, and indexes. Truncate a table. Execute a stored procedure. Use the result set returned from a query