Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

SQL ELT optimization using an Amazon Redshift V2 connection

SQL ELT optimization
using an Amazon Redshift V2 connection

You can configure
SQL ELT optimization
for a mapping that contains an Amazon Redshift V2 connection.
SQL ELT optimization
enhances the mapping performance.
When you run a task configured for
SQL ELT optimization
, the task converts the transformation logic to Amazon Redshift queries. The task sends the queries to Amazon Redshift and the mapping logic is processed in the Amazon Redshift database.
When you can configure
SQL ELT optimization
in a mapping to read from Amazon Redshift using an Amazon Redshift V2 connection, you can read data from tables, external tables, views, and materialized views.
Example
You work for a rapidly growing data science organization. Your organization develops software products to analyze financials, building financial graphs connecting people profiles, companies, jobs, advertisers, and publishers. The organization uses infrastructure based on Amazon Web Services and stores its data in Amazon S3. The organization plans to implement a business intelligence service to build visualization and perform real-time analysis. You can load data from Amazon S3 to Amazon Redshift by configuring the transformations using the AWS commands, to support the adequate data warehouse model and the consuming requirements.
Create an Amazon S3 V2 connection to read data form the Amazon S3 source. Create an Amazon Redshift V2 connection and use
SQL ELT optimization
to write data to the Amazon Redshift target. Using the Amazon Redshift V2 connection with
SQL ELT optimization
enhances the performances and reduces the cost involved.

0 COMMENTS

We’d like to hear from you!