Forum Discussion
Copy data activity creates no proper delta table with schema in Lakehouse
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.
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
If this is helpful, please accept the solution and give kudos
3 Replies
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
If this is helpful, please accept the solution and give kudos
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. 😁
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.
