When you configure a SQL transformation in a mapping enabled for

SQL ELT optimization

and use the DATE_PART function in a query, the task fails. You can only configure a SQL transformation using the simple SELECT statement for any Redshift supported scalar function with the prescribed format.

When you configure a SQL transformation in a mapping with user-defined functions that have date, decimal, or smallint data types, the mapping fails. As a workaround, configure user-defined functions in Redshift only with the corresponding transformation data types supported in Amazon Redshift.

When you run a mapping with SQL transformation, and define user-defined functions (UDFs) with Unicode or special characters, enclose the schema and UDF in double quotes.

When you run a mapping with SQL transformation having multiple select queries, the mapping fails. Amazon Redshift only supports SQL transformations with a single simple select query.

When you use user-defined functions and scalar functions together in the same query to partially push down a mapping logic, the mapping fails if the target data type does not match with the source type. As a workaround, you can enable full

SQL ELT optimization

or define only scalar functions in the query.