question

Bhanu-9326 avatar image
0 Votes"
Bhanu-9326 asked Bhanu-9326 commented

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

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

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered Bhanu-9326 commented

Hello @Bhanu-9326,

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://docs.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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This is snapshot table , we should not drop the table .

0 Votes 0 ·