Switching a Dataset to a Workbench

ColinHaze
ColinHaze Member
in Workbench

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

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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!

    If I solved your problem, please select "yes" above

  • Chris_Wolman
    Chris_Wolman Contributor
    Answer ✓

    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

    image.png image.png

    Chris

Answers

  • ColemenWilson
    ColemenWilson Coach

    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.

    If I solved your problem, please select "yes" above

  • ColinHaze
    ColinHaze Member

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

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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!

    If I solved your problem, please select "yes" above

  • Chris_Wolman
    Chris_Wolman Contributor
    Answer ✓

    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

    image.png image.png

    Chris

  • ColemenWilson
    ColemenWilson Coach

    @Chris_Wolman Awesome! I stand corrected!

    If I solved your problem, please select "yes" above

  • david_cunningham
    david_cunningham Coach

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

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Categories