The Copy data activity is a powerful tool for moving data between data 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 supports a number of tools capable of large-scale data transformation, one of which is Azure Databricks. Databricks is a cloud-based ...
