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

Variables with Amazon Redshift V2

Variables with Amazon Redshift V2

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.

0 COMMENTS

We’d like to hear from you!