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
Data Integration
supports and the corresponding transformation data types:
Amazon Redshift Data Type
Transformation Data Type
Description and Range
Bigint
Bigint
Signed eight-byte integer
-9223372036854775808 to 9223372036854775807
Boolean
Small Integer
Logical Boolean (true/false)
Char
String
Fixed-length character string
Max value 4096 bytes
Date
Timestamp
Calendar date (year, month, day)
4713 BC to 294276 AD
Decimal
Decimal
Exact numeric of selectable precision
Max precision is 38, scale is 37
Double Precision
Double
Double precision floating-point number
15 significant digits of precision
Integer
Integer
Signed four-byte integer
-2147483648 to +2147483647
Real
Double
Single precision floating-point number
6 significant digits of precision
Smallint
Small Integer
Signed two-byte integer
-32768 to +32767
Timestamp
Timestamp
Date and time (without time zone)
4713 BC to 294276 AD (with up to a maximum of six digits of precision for fractional seconds)
Varchar
String
Variable-length character string with a user-defined limit
Max value 65535 bytes
For the decimal data type, the numeric value for the precision (38, 37) is rounded off after the16th precision. The remaining digits are replaced with zeroes.
For example, the value
2.3121356348957890888898699898989999990
in source is rounded off to
2.3121356348957890000000000000000000000
in target.
To resolve the issue, specify the precision as less than or equal to 28.