You can use full SQL ELT to push the SYSDATE variable to the Amazon Redshift database in an expression transformation.
When you use full SQL ELT to push the SYSDATE variable, it corresponds to the date/time data type of the Amazon Redshift cluster, while for mappings without
SQL ELT optimization
the SYSDATE variable corresponds to the date/time data type of the agent.