Dss failed to read from table (Column "X" does not exist)

[Romain_L]

Hello I explain you my problem.

I had a table in DSS that I rebuilt by changing the schema (I deleted a column).

The problem is that Dataiku does not want to display the table anymore (Image below)

It tells me that the column "MD_ID" doesn't exist so I don't use it at all anymore (neither in my recipe nor in the schema in the table).

On the other hand I can use this dataseet as an entry in a new recipe or in a Notebook. The bug comes only from the display in "Explore".

I don't know if you have already encountered this bug and if so how to solve it?

Thank you in advance for your answers 😊

[AlexT]

Hi,

Could you try navigating to the Settings of the Dataset and click on Schema - Check now

The on the Explore tab can you click on Save and Refresh Sample 

If the error persists please share the exact DSS version you are currently on. 

[Romain_L]

Hi !

I confirm you that Schema and Data are consistent.

In the preview tab I also have the preview of my dataset displayed.

But in the explore tab. Still the same error and I can't access the sample configuration interface.

I am on version 9.0.0

Thank you in advance 😊

[AlexT · Accepted solution]

HI,

Are you not able to click on the left edge side to expand the sample settings? 

[Romain_L]

Thank you very much I was able to find the problem.
It was because I had a filter on this old column 🤣! A really stupid oversight sorry!
Thanks again and have a nice day 😊