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

Rules and guidelines for configuring SQL query

Rules and guidelines for configuring SQL query

Consider the following rules and guidelines when you configure an SQL query:
  • You cannot override the default SQL query when you select the source type as
    Query
    .
  • If you enter date and timestamp columns in the
    SQL Query
    property, you must configure the date and timestamp columns in the following format:
    YYYY-MM-DD HH24:MI:SS.MS
  • When you specify an SQL query in the source, the boolean values are written as 0 or false to the target.