Search code examples
azure-data-factory

Azure Data Factory Auto create table requesting table exists before copying

I am trying to copy to Azure SQLDB.

This is a straight forward copy and I requested 'Auto create table'. My understanding is that ADF will automatically create the table if not is specified.

enter image description here

However, when I attempt to copy to Azure SQLDB I get the error "Table is required for Copy Activity"

I should mention the source is a sharepointpoint list, see image. However, I didn't see how that should be the problem. enter image description here

enter image description here

Any thoughts on where I'm getting the error?

I am updating question with Dataset Database Properties enter image description here

Solution

  • Open the Copy activity > Sink > Dataset > Table > Edit > type in the table name that should get created and run the pipeline.

    Table that doesn't exist should get auto created

    Similar thread : https://learn.microsoft.com/en-us/answers/questions/471851/data-factory-auto-create-table-in-copy-activity-do