We are trying to create a report with list of datasets with data sources used in that data sets and magic ETL used in that data set. Is there any way to pull this information ?
You should look at the Domo Governance / Domo Stats datasets that are available in the app store. Search the app store for Governance or Stats and you will see the different datasets that are available to you. They provide a lot of this information for you as well as some pre-built cards. You can then tweak the cards if you are needing something slightly different.