The Copy activity is a powerful tool for moving data between storage systems, but it has limited support for data transformation. Columns can be added to the activity’s source configuration, or removed by excluding them from the source to sink mapping, but the activity does not support manipulation of individual rows or allow data sources to be combined or separated.
The Azure platform offers a number of tools based on Apache Spark, including Azure Databricks, Azure Synapse Analytics Spark pools, and Azure HDInsight. Apache ...
