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 support analytic workloads efficiently. It is based on PostgreSQL and designed specifically for large-scale analytics and reporting.

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

Amazon Redshift data types we support

INTEGRAL:

bigint (int8)nteger (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:

datetimeimestamp (timestamp without time zone)timestamptz (timestamp with time zone)

LARGE OBJECTS:

geographyvarchar(max)

OTHER:

boolean (bool)