Known issue - Pipeline can't copy an empty table to lakehouse

You can create a pipeline to copy data from a source lakehouse to a destination lakehouse. If the source lakehouse table is empty (it contains schema information but no rows), the copy activity fails.

Status: Open

Product Experience: Data Factory

Symptoms

When you copy data in a pipeline, the copy activity fails with an error. The error code is MissingSchemaForAutoCreateTable and the error message is similar to Failed to auto create table for no schema found in Source. This issue happens when the destination is an empty lakehouse table.

Solutions and workarounds

Currently, copy has a limitation when handling the empty lakehouse table. To work around this issue, edit the mapping page. Select + New Mapping to add the columns individually.

Next steps

• About known issues