Amazon Redshift

Amazon Redshift
Database background

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)

SQL Flow handles automatically

The software does the migration work.

  • SQL Flow selects provider-aware reading, type handling, and loading behavior.
  • Supported capabilities and prerequisites are matched to the chosen database.
  • Database-specific differences are applied without rebuilding the migration.

You choose

Keep control of the decisions that matter.

  • Choose the source and target database.
  • Select among available full-load and CDC modes.
  • Choose type mappings and target creation policy.