Switching a Dataset to a Workbench

Options

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
    Answer ✓
    Options

    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 ✓
    Options

    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

    Chris

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

Answers

  • ColemenWilson
    Options

    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
    Options

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

  • ColemenWilson
    Answer ✓
    Options

    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 ✓
    Options

    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

    Chris

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

  • ColemenWilson
    Options

    @Chris_Wolman Awesome! I stand corrected!

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

  • david_cunningham
    Options

    @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! ✔️**