Daniel Willén on 25 Sep 2023 13:05:37
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.
Administrator on 25 Oct 2023 01:05:11
Could you elaborate in detail on what type of schemas capability needed in copy activity? Any specific on copy pairs?