You now have until September 15th to submit your use case or success story to the 2022 Dataiku Frontrunner Awards!ENTER YOUR SUBMISSION

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

Solved!
Romain_L
Level 3
Dss failed to read from table (Column "X" does not exist)

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)

 

BugAffichageDSS.png

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 😊

0 Kudos
1 Solution
AlexT
Dataiker
Dataiker

HI,

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

Screenshot 2021-08-02 at 09.50.46.png

View solution in original post

4 Replies
AlexT
Dataiker
Dataiker

Hi,

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

Screenshot 2021-08-02 at 08.39.50.png

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

Screenshot 2021-08-02 at 08.40.58.png

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

Romain_L
Level 3
Author

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 😊

 

 

0 Kudos
AlexT
Dataiker
Dataiker

HI,

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

Screenshot 2021-08-02 at 09.50.46.png

Romain_L
Level 3
Author

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 😊

0 Kudos

Labels

?
Labels (3)
A banner prompting to get Dataiku