For a cloud data lake to cloud data warehouse integration,
Data Integration
intelligently identifies the opportunities to leverage cloud ecosystem or cloud data warehouse APIs for data pipeline processing.
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.