if we enable allow schema drift option in both source and sink ,the newly added column will get created automatinally in sink ? if table action :None

Question

if we enable allow schema drift option in both source and sink ,the newly added column will get created automatically in sink ? if table action :None

Answer 1

Hello @Bhanu ,

Welcome to the Microsoft Q&A platform.

Yes, schema drift option will help you to add columns automatically to Sink table only if you select Table option as Recreate.

Note: If you select Table option as None or Truncate Table then newly added column from source will not get create in your Sink Table.

Please check below link to know more about Schema drift in Source and Sink Transformations

https://learn.microsoft.com/en-us/azure/data-factory/concepts-data-flow-schema-drift

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.