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

Amazon Redshift and transformation data types

Amazon Redshift and transformation data types

The following table lists the Amazon Redshift data types that the runtime environment supports and the corresponding transformation data types:
Amazon Redshift Data Type
Transformation Data Type
Description
Bigint
Bigint
Signed eight-byte integer.
Boolean
Small Integer
Logical Boolean (true/false).
Char
String
Fixed-length character string.
Date
Timestamp
Calendar date (year, month, day).
Decimal
Decimal
Exact numeric of selectable precision.
Double Precision
Double
Double precision floating-point number.
Integer
Integer
Signed four-byte integer.
Real
Double
Single precision floating-point number.
Smallint
Small Integer
Signed two-byte integer.
Timestamp
Timestamp
Date and time (without time zone).
Varchar
String
Variable-length character string with a user-defined limit.