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

Invalid number of columns in query while writing to a dataset

jvijayakumar2
Level 3
Level 3
Invalid number of columns in query while writing to a dataset

I get the following error while trying to run a recipe that writes to a newly created dataset. Please help!

Capture.PNGCapture.PNG

0 Kudos
2 Replies
sergeyd
Dataiker
Dataiker

Hi @jvijayakumar2 

Quite often, prepare recipes change dataset schema (adding/removing columns). In all such cases when you run the recipe, DSS will ask you if you want to accept schema changes. When you do this, the output dataset will have the correct number and types of columns. If you do not do this, you will get an error like you shown on the screenshot. 

You can try navigating to the output dataset->Settings->Schema and hit "Check now". You should see a message to accept new schema. 

0 Kudos
jvijayakumar2
Level 3
Level 3
Author

Thanks for your reply! The schema seems to be good but the error wouldn't go away.

0 Kudos