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

Supported operators for Amazon Redshift V2 mappings

Supported operators for Amazon Redshift V2 mappings

When you use pushdown optimization, the Secure Agent converts the expression in the transformation by determining equivalent operators in the database. If there is no equivalent operator, the Secure Agent processes the transformation logic.
The following table lists the pushdown operators that can be used in an Amazon Redshift database. Columns marked with an X indicate that the operator can be pushed to the Amazon Redshift database by using full pushdown optimization.
Operator
Pushdown
+
X
-
X
*
X
/
X
%
X
||
X
>
X
<
X
=
X
>=
X
<=
X
!=
X
AND
X
OR
X
NOT
X