Forum Discussion
Unable to identify these objects as tables. To keep these objects in the lakehouse, move them to Fil
I believe I figured out the issue over the weekend, but will be doing some additional testing tomorrow. Previously, I was connected to SQL server on prem using an on-premise gateway in Fabric using gateway version 3000.234 on one of our VMs which was writing data to the Unidentified data folder inside of it's own schema in Fabric and was unable to write the data correctly into the lakehouse. The delta parquet files were still visible inside of the sql end point, but the lakehouse looked jacked up like in the screenshot PraveenVeli posted above. We were able to update the gateway version over the wekeend to 3000.246 on our VM and it appears it has fixed the issue and I am now able to see the data in the lakehouse exactly as required.
Thank you joseph_campbell . Updating Gateway did the trick and resolved the issue. Thanks alot for your help on this.
Hi PraveenVeli ,
The error message indicates that Lakehouse does not recognize these objects as tables and therefore cannot load the data correctly.
I ran the test:
I was able to reproduce your error when setting the pipeline destination to a normal lakehouse without schema preview enabled.
Set destination to lakehouse with schema preview enabled, and manually specify the table to load data into under the dbo schema, which can be run successfully, the table is displayed normally, and no error is reported.
Table run successfully and load properly even if the schema name is specified manually.
There are two workarounds:
- Like the test screenshot I showed earlier, you can try loading the tables in SQL Server into a lakehouse with schema preview enabled.
- Use dataflow Gen2 to import the data from SQL Server to the lakehouse.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi Anonymous , Thank you for getting back on this. Issue still persists for me. Surprisingly it never goes to dbo schema for me or any other schema that i give in there. Something very similart to this link https://community.fabric.microsoft.com/t5/Data-Pipeline/Copy-activity-into-Lakehouse-with-schemas-enabled/m-p/4324306. Coming to my data load issue i tried these two options
And it still comes up as below
Not sure if capacity region makes a difference. I'm using trail version with region as North Central US.