Amazon Redshift Connectors

Back Next

Create a mapping in SQL ELT mode

In a mapping in SQL ELT mode, you don't have to specify an optimization type. Data Integration pushes the transformation logic by default to the target database.

When you run a mapping in SQL ELT mode, you can load data from the following data sources to Amazon Redshift:

Amazon Redshift

Amazon S3

To create a mapping in SQL ELT mode, you create a mapping and select

Mapping - SQL ELT

as the mapping type.

Select the cloud ecosystem where you want all the mapping logic to be processed.

You're then prompted to select the target connection.

The mapping is automatically configured with the target connection you chose.

You can add additional transformations to the mapping. The transformations available in the transformation palette are transformations that the target endpoint can process. You can also preview data for individual transformations to validate the mapping logic.

For more information on mappings in SQL ELT mode, see Mappings in SQL ELT mode for Amazon Redshift.

SQL ELT configuration options

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal