Issue with Table display in Lakehouse Interface

[dbyba]

Hi,

I am experiencing an issue with a table in the lakehouse. Although the table contains data, it doesn't display anything in the lakehouse interface. However, when I retrieve the data in a notebook, it appears correctly.

I have checked permissions, refreshed the table in lakehouse and sql endpoint mode, and verified the data format, but the issue persists.

this is the table in Lakehouse UI

but in a Notebook I can get data

Could anyone assist me in resolving this?

Thank you for your help.

[dbyba]

Hi @Anonymous 

Thank you for your answer, the table is in delta format as you can see in the image 

the table is retrieved from an oracle database using copy data, data is inserted into table in the lakehouse directly with overwite mode, a pipeline is running every day to retrieve data, I'd like to mention that we had no problems before until one day I noticed that the table wasn't displaying any data, there's no impact on the data for the moment as it can be retrieved with an sql query, but I find it weird that we can't see it in the lakehouse

Thank you for your help 🙂

[Anonymous]

Hi @dbyba ,

I noticed that your table icon is not delta table icon.

If the tables are not in Delta table format, the Lakehouse interface may not display the data for those tables, but the data can still be retrieved by querying with a SQL statement. This is because the Lakehouse interface primarily supports the Delta Lake format, while SQL queries have direct access to the underlying data format.

To ensure that the tables display correctly in the Lakehouse interface, it is recommended that the tables be converted to Delta format.

I would like to know how your tables are created? Was it by uploading a CSV file? Or did you use Dataflow Gen2 or Data Pipeline, or some other way? This information would be helpful to me in solving your problem.

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!