Changing the input datasource to multiple ETLs at once

rahulrampa
rahulrampa Member
in Datasets

I have a table that powers multiple ETLs and I want to change this table in all the ETLs to another table without changing it individually in each ETL. Is there a way I can do this or view what ETLs are powered via Domostats ( I know I can check this in the Lineage tab) but I want it in a table so that I can analyze the impact better.

Tagged:

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    Yes, this is the "DataFlow Input DataSource" report in DomoStats. (this reports out dataflow IDs and datasource IDs, so if you need their names, you'd need to join it with other DomoStats reports).

    Once you've determined the impact, depending on the type of data, you can probably change the input table within the setting of that datasource, which would have the effect of changing the input for all the downstream ETLs.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    Yes, this is the "DataFlow Input DataSource" report in DomoStats. (this reports out dataflow IDs and datasource IDs, so if you need their names, you'd need to join it with other DomoStats reports).

    Once you've determined the impact, depending on the type of data, you can probably change the input table within the setting of that datasource, which would have the effect of changing the input for all the downstream ETLs.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories