Preface
Introduction to Amazon S3 V2 Connector
- Amazon S3 V2 Connector assets
- Introduction to Amazon S3
Connections for Amazon S3 V2
Amazon S3 V2 sources and targets
Mappings and mapping tasks with Amazon S3 V2
- Amazon S3 V2 objects in mappings
Migrating a mapping
- Use the same object path for the migrated mapping
  - Rules and guidelines for the same object path
- Use a different object path for the migrated mapping
  - Migration options
    - Parameterization rules
  - Rules and guidelines
Upgrading to Amazon S3 V2 Connector
Data type reference
Troubleshooting
- Troubleshooting for Amazon S3 V2 Connector
- Troubleshooting FAQ

Amazon S3 V2 Connector

Back Next

SQL ELT optimization

You can enable full

SQL ELT optimization

when you want to load data from Amazon S3 sources to your data warehouse in Amazon Redshift. While loading the data to Amazon Redshift, you can transform the data as per your data warehouse model and requirements. When you enable full

SQL ELT optimization

on a mapping task, the mapping logic is pushed to the AWS environment to leverage AWS commands.

You cannot configure

SQL ELT optimization

for a task based on a mapping configured in advanced mode.

For more information on

SQL ELT optimization

, see the help for Amazon Redshift V2 Connector. If your use case involves loading data to any other supported cloud data warehouse, see the connector help for the applicable cloud data warehouse.

Rename Saved Search

Table of Contents

Amazon S3 V2 Connector

Amazon S3 V2 Connector

SQL ELT optimization

SQL ELT optimization