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.