locked
Question regarding bulk data loading from Data Factory RRS feed

  • Question

  • Hi All,

    I am referring to the below article on copying bulk data

    https://docs.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal

    In the above article, I see that the tables are already present at source (A - SQL DB).However, the there is no mention whether the tables are already present at Sink(A - SQL DWH). Do we need to manually create the tables at the sink(DWH) before triggering pipeline or the tables will get created automatically ?

    Or is it the turn of Polybase to create them before loading.. I am aware of polybase but I always saw that we need to manually create the table while using polybase.

    Please reply and let me know if any inputs are required

    Thanks

    Surya

    Wednesday, January 30, 2019 3:37 AM

All replies

  • Hi Surya,

    As mentioned in the prerequisites Create corresponding table schemas in SQL Data Warehouse. You can use Migration Utility to migrate schema from Azure SQL Database to Azure SQL Data Warehouse. You use Azure Data Factory to migrate/copy data in a later step.

    For more info, please refer to the prerequisites here :

    https://docs.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal#prerequisites

    Let us know if this helps. Else we can continue to probe in further.


    MSDN

    Thursday, January 31, 2019 8:07 PM