Schema drift RRS feed

  • Question

  • Hi,

    I am trying to transfer data from staging table to final table in Azure SQL database using data flow. 

    If i enable allow schema drift and infer schema drift options; the final table or sink has to be recreated. Is there a way to recreate the table and insert the data into the table without having to go to the extra copy step? This would be two copy steps- copy data from source to staging and again from staging to final if there is a schema change.

    Any other best practices to do so?


    • Edited by raosee Monday, February 3, 2020 5:58 PM
    Monday, February 3, 2020 5:49 PM

All replies