Metadata Injection
If you you need to create 'almost' the same pipeline a lot of times, consider using Metadata Injection to create re-usable template pipelines.
-
Avoid manual population of dialogs
-
Whenever you need dynamic ETL
-
Supports data streaming
As example use cases is Loading data from 50 different file formats into a database with one pipeline template. This helps you to automatically normalize and load property sets.