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.
Hey, I just submitted a post here recently and am running into the exact same issue.
The Lakehouse I have does have schema preview enabled. And I have an existing pipeline that can specify schema and insert data into a table vs creating a schema based off the table name. I created a second pipeline to bring in data from a different sql server source and am running into this issue where I can't even load the data into the default schema, nevermind a secondary or custom schema.
After the pipeline runs it creates a new schema based off the table name and puts the delta file in an Unidentified folder. I don't see a solution for this, is this a bug, because it seems like this is a common and very critical issue without a solution...
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.