Workbench Job Schema

Rohil
Rohil ⚪️
in Workbench

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

  • guitarhero23
    guitarhero23 🟢

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

     

    Dojo Help 901.JPG


    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**
  • Rohil
    Rohil ⚪️

    Thanks.

    Will check and see if it works.

This discussion has been closed.

Categories