Copy data into Lakehouse doesn't support schemas. Right now when you copy data from one SQL server to another (Suppose you want to copy myschma.mytable) , the pipeline just renames your table myschema_mytable , and so in the destination you end up with dbo.myschema_mytable when you really want the same schema and table name as in your source.
3 Comments
Copy activity now supports to read schema info from Lakehouse table and write into specified schema in Lakehouse table.
- Status added:Completed
