Switching a Dataset to a Workbench

ColinHaze

Hi,

I have a dataset that I update manually and use in multiple ETLS.

What would be the easiest way to get that going through Workbench without having to create a new dataset. Unless that's the only way.

Thank you

ColemenWilson

It could if you have beastmodes saved to the old dataset that are not in the cards/dashboards. But if they are saved on the cards and the fields stay the same, they should still work. Definitely test with 1 ETL before switching them all over!

Chris_Wolman

Hello @ColinHaze,

You can configure a workbench job to use an existing dataset by expanding the Domo Details section. Next to the Dataset Name is a browse button. Press this button. Click on the Connector DataSets tab and locate the dataset you want the workbench job to use. Click the Select button. I would recommend making a backup of your dataset just in case something goes wrong so you do not lose all of the data unless it is something you can reupload easy enough.

Chris

ColemenWilson

You'd have to create a new dataset via Workbench, once done you could swap the datasets in your ETLs. As long as the schema is the same, it shouldn't have a negative downstream impact.

ColinHaze

@ColemenWilson I thought that was the only way. Its the exact same schema, will this have a negative effect on beastmodes?

ColemenWilson

It could if you have beastmodes saved to the old dataset that are not in the cards/dashboards. But if they are saved on the cards and the fields stay the same, they should still work. Definitely test with 1 ETL before switching them all over!

Chris_Wolman

Hello @ColinHaze,

You can configure a workbench job to use an existing dataset by expanding the Domo Details section. Next to the Dataset Name is a browse button. Press this button. Click on the Connector DataSets tab and locate the dataset you want the workbench job to use. Click the Select button. I would recommend making a backup of your dataset just in case something goes wrong so you do not lose all of the data unless it is something you can reupload easy enough.

Chris

ColemenWilson

@Chris_Wolman Awesome! I stand corrected!

david_cunningham

@Chris_Wolman this is great to know! Thanks for sharing 😁