how to Copy data from synapse database by skipping some coloumns using azure data factory

Question

Hi Team,

I want to copy table from one synapse database to another and in this i want to skip two coloumns means except these two columns entire table should be copied to target synapse database and i want to this with azure data factory.

is this scenario possible ? and if yes then please tell me how to do this.

Thanks & Regards,
Jezz

Answer 1

Hello @jessy ,

You can copy data from the Azure Synapse database by skipping some columns using Azure Data Factory as show below:

For example, to copy data from one Azure Synapse Database to another and explicitly map your columns as shown:

On copy activity, => mapping tab, click Import schemas button.

Map the needed fields and exclude/delete the rest (Select the fields which you want to exclude and click on the delete button).

Azure Synapse Analytics Source table data:

Copy data from synapse database by skipping some columns (PickupTimeID & DropoffTimeID) using azure data factory as shown:

Azure Synapse Analytics Sink table data:

In case, if you want to do it using Azure Data Flows, you may refer similar SO thread addressing the same.

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.