Magic ETL 1.0 rename Output Dataset

mattwelykholowa

Hi, I am working on a dataflow to take an input dataset and write an output CSV file based on another vendor naming convention. Is there a way that I can automatically name the output dataset in this format? Example: Output dataset = CU_CSV_FILE_YYYYMMDD.csv so for today it would be CU_CSV_FILE_20210423.csv. thx!

MarkSnodgrass

I have the Magic ETL 2.0 beta and it is still a manual process as well. It is interesting idea and you might want to submit it in the Ideas Exchange section of Domo for future consideration.

MarkSnodgrass

You might be able to do this if programmatically via the Domo CLI or API tools. Within the main Domo Magic ETL interface, you must manually name your output datasets.

mattwelykholowa

Thanks Mark. Any idea if they will have this feature built into Magic ETL V2.0?

jaeW_at_Onyx

@mattwelykholowa

I wouldn't hold my breath... this isn't exactly a feature that would be oft requested.

What you could do is either

1) try to hack the ETL using the Domo CLI to alter the dataset or alter the dataflow like i demonstrate in this video.

https://www.youtube.com/watch?v=YgJLijj7vmw&list=PLUy_qbtzH0S4eYAu13c-NMnyOuxJwspzh&index=1

or 2) just use a script + export-dataset command in the CLI to just export the dataset and name the file as you export it.

or 3) use the PyDomo, Python SDK,

https://www.youtube.com/watch?v=-e8HWjpE7cU