Is there a way to create a copy of dataset (Not data flow)?

yli_2596
yli_2596 βšͺ️


Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon πŸ₯·

    You can use the Dataset Copy connector to copy a dataset. Go to the data center and click on connectors and search for dataset copy.

    https://domohelp.domo.com/hc/en-us/articles/360043436533-DataSet-Copy-DataSet-Connector




    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • yli_2596
    yli_2596 βšͺ️

    First of all, this is very helpful.

    However, this is not exactly what I need. I am hoping to create a copy of instance then change the settings. For example, copy a SQL dataset then make some changes on SQL query.

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon πŸ₯·

    If you are talking about changing a SQL query, then are you talking about a dataset created in Domo Workbench? Where would you be making the SQL changes?




    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • yli_2596
    yli_2596 βšͺ️

    Please see below.


  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon πŸ₯·

    There really isn't a copy function for datasets. You just have to create a new connection and copy and paste details over to your new one.

    The Java CLI command tool might be able to do it. Honestly, though, it would take more time to figure out the correct syntax than it would just to make a new connector that I just described.




    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    +1 @MarkSnodgrass

    Yes you can duplicate connectors using APIs, but getting the syntax correct is such a hassle. Unless you have tens of connectors, just going through the process would probably be most time efficient.

    Jae Wilson
    Check out my πŸŽ₯ Domo Training YouTube Channel πŸ‘¨β€πŸ’»

    **Say "Thanks" by clicking the ❀️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"