Forum Discussion
pflorenzano
Apr 22, 2020Copper Contributor
Copy Activity in Azure Data Factory (V2) supports creating a destination table automatically
Hello, I was recently working with a client who was looking to export data from a 3rd party database to Azure SQL Database. Because of the amount of tables they wanted to export, the option to a...
micahj77
Apr 24, 2021Copper Contributor
Great observation. Running into difficulties with the 'auto create tables' option myself as well.
It would make a TON of sense for this feature to either.
1. Detect a simple header column in any incoming data source and use those headers as table columns (Why this is difficult is beyond me, I've rarely seen this be a challenging feature to code on any other software suite that handles incoming data).
2. Automatically hide the option to 'auto create tables' IF the "data source" = "one that data factory doesn't like".
Leaving this option wide open and then throwing an error leaves the end user confused. It doesn't ever indicate that your data source type won't actually allow you to automatically create tables.