Workbench Job Schema

Hello,

 

Here is the situation:

I have scheduled Workbench job whose source is a DB view. There is a column in view's underlying table called  'Sales ' of datatype float. Till date the data in it was integer numbers. The Workbench Job was executing fine. when i added a decimal value into the Sales field, the scheduled Job failed saying 

"Workbench DataSet Job schema does not match Domo DataSet schema..."

So my question is :

  • Is the Workbench determining the column Datatype based on the content of that particular column values when the job is created?

Only the scheduled job fails in this situation, a manual run changes the schema and will not fail. 

 

Looking forward to your insights on this.

Regards,

Rohill

Comments

  • Have you tried checking off the setting under "Configure>Additional settings>Allow schema changes"?

     

    Dojo Help 901.JPG

  • Thanks.

    Will check and see if it works.

This discussion has been closed.