Search code examples
azure-sql-databaseazure-data-factoryazure-blob-storage

How to copy selected columns from ADLS table to Azure Sql database using azure data factory


I'm trying to copy selected columns from ADLS table to Azure sql database.

i created a dataset fror source and sink side, then what next step


Solution

  • In the mapping section of the Copy activity, Import the schemas across the source and the sink datasets and then delete the column mappings which you do not need and only keep the columns that you need to copy over