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 Data activity doesn't work properly with Lakehouses under schema structures.
When configuring the destination with the schema and table name, it ignores the schema name and creates a new schema with the name of the table.
The table is unreadable
