Data Factory auto create table in Copy activity doesn't seem to work, or isn't very useful

Cornel Verster 36 Reputation points

Hi there

I'm trying to create copy activities where the source table is replicated into the Sink database, and the table is created according to what is in the Source. I know there is the "Auto create table" option when making the copy activity, but when I check this, it still tells me that I need to select a Sink table. This is exactly what I'm trying to avoid, as I want it to replicate the Source table in my Sink database, and I would expect that is what auto create table is supposed to do?

How do I get the copy activity to replicate the Source table without having to create the table manually in my Sink database?

Kind regards

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,018 questions
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,211 Reputation points

    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

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Saf Sied 1 Reputation point

    To add to what he suggested. When you open the Copy activity > Sink > Dataset > Table > Edit > there will be two text boxes in front of Tabe. Make sure in the first box you enter schema name (usually default schema dbo) and in the second box you enter your table name:

    0 comments No comments