When to use this flow type
Any to Any ETL flow is a flavor of the flow type Extract data from source, transform, and load in destination.
Unlike all other flows in this group, Any to Any ETL flow allows developers to include different types of source-to-destination transformations within the same flow.
For example, you can pipeline the transformation which extracts data from a web service and loads it into the temporary database with the transformation which loads data from the temp database into multiple targets: databases, files, etc.
Read how to use Any to Any ETL flow to apply JOIN and SET transformations to the multiple heterogeneous data sources.
Note that you can achieve the same goal by using Nested Flow. Unlike nested flow that can include any flow types (even other nested flows), Any to Any ETL flow is limited to source-to-destination transformations.
To create a flow, go to Flows window, click the
+ button and type in
any to any. Select the flow and add one or multiple source-to-destination transformations.
Do not use Any to Any ETL flow to load data into Snowflake and Redshift
Snowflake and Amazon Redshift are the columnar databases, optimized for data retrieval operations, so loading data into using DML statements (INSERT/UPDATE/DELETE) can be quite slow, especially for larger datasets.