Workbench Job Schema

Rohil

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

guitarhero23

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

 

Rohil

Thanks.

Will check and see if it works.