Changing the input datasource to multiple ETLs at once

rahulrampa

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.

DavidChurchman

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.

DavidChurchman

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.