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.
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.
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?
Please see below.
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.
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.