Using SQL ELT optimization,

Data Integration

pushes the processing down to the cloud ecosystems or cloud data warehouses. This improves the data processing performance as data is processed close to the source and saves your company data transfer costs.

Data Integration

supports full SQL ELT optimization for cloud data warehouse to cloud data warehouse integrations.

Data Integration

converts mapping logic to equivalent, optimized SQL queries that the cloud data warehouse executes, without data transfers that would normally incur additional processing time and data transfer charges.

Data Integration

uses the cloud data warehouse's compute capacity to process the data without additional resources, thus achieving compute efficiency.

Try to use SQL ELT optimization for cloud data lake to cloud data warehouse or cloud data warehouse to cloud data warehouse integrations whenever SQL ELT optimization is supported.