Redshift Data Types | Guide to AWS Redshift Data Types

in Redshift
 • Updated on 

Many of our customers have a variety of data sets with different data types coming from different sources. Here at FlyData, we replicate your data from Amazon RDS to Amazon Redshift in near real-time, but unfortunately, we cannot support all of the source data types due to the current limitations of Amazon Redshift. For a table or column to successfully replicate from the source to the target, your data structure must adhere to the supported Amazon Redshift data types.

Below is a quick reference of the currently supported data types in Amazon Redshift:

Data type Aliases Description
SMALLINT INT2 Signed two-byte integer
INTEGER INT, INT4 Signed four-byte integer
BIGINT INT8 Signed eight-byte integer
DECIMAL NUMERIC Exact numeric of selectable precision
REAL FLOAT4 Single precision floating-point number
DOUBLE PRECISION FLOAT8, FLOAT Double precision floating-point number
BOOLEAN BOOL Logical Boolean (true/false)
CHAR CHARACTER, NCHAR, BPCHAR Fixed-length character string
VARCHAR CHARACTER VARYING, NVARCHAR, TEXT Variable-length character string with a user-defined limit
DATE Calendar date (year, month, day)
TIMESTAMP TIMESTAMP WITHOUT TIME ZONE Date and time (without time zone)
TIMESTAMPTZ TIMESTAMP WITH TIME ZONE Date and time (with time zone)

We are confident as Amazon Redshift matures more data types will be supported, however at this time only the above data types are supported. Any tables and/or columns which do not adhere to this structure, unfortunately, will not be replicated. While there are ways to work around this, we suggest as a best practice to structure your data to match the currently supported data types in Amazon Redshift.

If you have any questions or need assistance, please reach out to us at support@flydata.com

Worry-free replication from source to Redshift & Snowflake
Unlimited sync during trial
No credit-card required
World class support
Try FlyData for free
Amazon Partner Logo Certified AWS
Redshift partner
Get started. Try FlyData.
Quick setup. No credit card required. Unlimited sync during trial.
Fast and secure Enterprise-grade security and near real-time sync.
World-class support Proactive monitoring from technical experts, 24/7.
Straightforward pricing Pay for the rows you use, and nothing you don’t.