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.