Create table when copying to SQL DB RRS feed

  • Question

  • Hi, I'd like to know if it's possible to create a table when copying data in Data Factory, I'm dealing with a 4000x5000 table and I'm not creating it manually!
    Friday, July 6, 2018 12:22 PM

All replies

  • Hi, 

    There's one scenario in ADF where it will automatically create the target table - that is, when copying from SQL table to SQL DW table, the target table can be auto created based on the source schema. What is the source of your data ?

    Friday, July 6, 2018 4:11 PM
  • I've been working on two different cases: mainly taking data from my ERP (a PostgreSQL DB) and also using Amazon S3 as the data source. I haven't found any way to create it automatically in these cases. 

    Wednesday, July 11, 2018 7:12 AM