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 mysche...
Copy activity now supports to read schema info from Lakehouse table and write into specified schema in Lakehouse table.
