Amazon Redshift

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. It uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes

Like many other data warehouses, Redshift uses columnar storage to allow analytic workloads. It is based on PostgreSQL.

Omni Loader is currently optimized for data ingestion from Redshift, but ingestion into Redshift is in development.

Amazon Redshift

data types we support

Integral:
bigint (int8)
integer (int, int4)
smallint (int2)
decimal:
decimal (numeric)
double precision (float, float8)
real (float4)
text:
char (character, nchar, bpchar)
varchar (character, varying, nvarchar, text)
varchar(max)
Binary
bitbinary
bit
timestamp
varbinary
Date/Time:
date
time
timestamp (timestamp without time zone)
timestamptz (timestamp with time zone)
Large objects:
geography
varchar(max)
Other:
boolean (bool)