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.

Omni Loader

We support Amazon Redshift directly. No additional drivers are required.

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)

Date/Time

date, time, timestamp (timestamp without time zone), timestamptz (timestamp with time zone)

Large objects

geometry, varchar(max)

Other

boolean (bool)