Here’s the difference between Hydra and Redshift. The comparison is based on pricing, deployment, business model, and other important factors.
Hydra is a data warehouse that is accessible from Postgres. You can start for free, begin scaling with Postgres, then switch to the data engine of your choice at any time. It's frictionless to swap back-end engines without lock-in.
Amazon Redshift is a fully managed petabyte scale data warehouse service. Redshift is designed for analytic workloads and connects to standard SQL based clients and business intelligence tools. Redshift delivers fast query and I/O performance for virtually any size dataset by using columnar storage technology and parallelizing and distributing queries across multiple nodes. Most common administrative tasks associated with provisioning, configuring, monitoring, backing up, and securing a data warehouse are automated.