Copy data activity creates no proper delta table with schema in Lakehouse

[SCWO]

Hi, 
I'm trying to get data from a REST API with an data copy activity directly into a Lakouse table with using the schema option.
My problem is, that the choosen schema in the copy activity is not taken into account and the table name becomes the schema in Lakhouse. Under that schema a folder is created with the delta file and a delta_log folder.  The preview of the table in Lakehouse is not working therefore.
When I try the same copy activity in a Lakhouse without schema the delta table is created properly. 

Does anybody know what I can do?

Thanks for any reply.

[SCWO]

@nilendraFabric 
Thanks for your reply.
Unfortunately to write the schema all lowercse is not a working solution.

But now I know I'm not alone with this problem. 😁

[nilendraFabric]

Hello @SCWO 

Thanks for confirming its not working. 
Its not ideal , but such bugs happens in Preview features. 

please accept this solution so it might help other community users. 

[nilendraFabric · Accepted solution]

Hello @SCWO 

The issue you’re experiencing with Fabric’s Copy Activity ignoring specified schemas in Lakehouse tables is a known limitation in the current preview implementation

there are multiple thread in this community around this issues

Workaround:

I can see you have uppercase letter in your schema name, please make sure all lowercase used

https://community.fabric.microsoft.com/t5/Data-Pipeline/Copy-activity-into-Lakehouse-with-schemas-en...

If this is helpful, please accept the solution and give kudos