Amazon Redshift Connectors

Back Next

Mappings in SQL ELT mode for Amazon Redshift

You can create mappings in SQL ELT mode to read data from Amazon Redshift or Amazon S3, load it to Amazon Redshift, and perform all of the data transformation within Amazon Redshift.

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

Mapping - SQL ELT

as the mapping type. You're then prompted to choose Amazon Redshift as the cloud ecosystem and an Amazon Redshift V2 target connection. If your organization doesn't have any Amazon Redshift V2 connections, you're prompted to create one.

After you choose the target connection, the Mapping Designer opens. When you create a mapping, a Source transformation and a Target transformation are already on the canvas for you to configure.

SQL ELT with Amazon Redshift V2 Connector

Sources in mappings in SQL ELT mode

Targets in mappings in SQL ELT mode

Transformations in mappings in SQL ELT mode

Functions in mappings in SQL ELT mode

Operators in mappings in SQL ELT mode

Rules and guidelines in mappings in SQL ELT mode

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities