Amazon Redshift – Your Petabyte-Scale Cloud Data Warehouse
Amazon Redshift in brief
Amazon Redshift is an enterprise-level cloud data warehouse by Amazon Web Services.
Amazon Redshift has continually been named a leader by Gartner, Forrester, IDC, etc., as a cost-effective cloud data warehousing solution with industry-leading performance. Among its most prominent features are flexible querying of data with SQL (including big data), near-unlimited agile scalability, federated queries support, automation of common DWH maintenance tasks, comprehensive security capabilities, etc.
Among Amazon Redshift renowned users are Pfizer, McDonald’s, FOX Corporation, Amazon.com, Intuit, Yelp, Western Digital, and more.
Allows deploying DWH in a few clicks.
Quick processing of data of various volumes and types.
Automated backups and continuous cluster health monitoring.
Flexible data querying with SQL (including big data).
Allows integrating spatial data into analytical queries.
Querying data lake using SQL with Redshift Spectrum.
Running queries on live data across the data warehouse, data lake, operational databases with no complex ETL jobs.
- AWS Lake Formation (data lake setup).
- AWS Glue (ETL).
- Amazon Kinesis Data Firehose (ETL for streaming data).
- Amazon EMR (data processing).
- Amazon QuickSight (BI service), etc.
Enhancing Amazon Redshift with the industry-leading tools for loading, transforming, analyzing and visualizing data (Power BI, Tableau, Informatica, Qlik, Talend Cloud, etc.)
Quick scaling of storage and compute resources.
Coordinated query processing by multiple computer processors.
Delivering precomputed/cached results for speeding up queries.
Speeding up query performance with columnar data storage, data compression, zone maps, compression encoding, etc.
Increasing query throughput and optimizing performance with varying workloads or user concurrency.
Flexible pricing options
- On-demand pricing with no up-front costs.
- Reserved instance pricing with the possibility to save up to 75%.
Managing pricing with three instance types, separation of storage and compute, and free daily concurrency scaling credits.
Security and compliance
Having data encrypted in transit and at rest with keys managed by default.
Meeting national, regional, and industry-specific compliance requirements including SOC, PCI DSS, FedRAMP, HIPAA, DoD CC SRG, IRAP, MTCS, C5, K-ISMS, ENS High, OSPAR, HITRUST CSF, etc .
Controlling network access to the DWH cluster with firewall rules.
Restricting data access with granular access controls.
ScienceSoft has been providing consultancy, implementation and support for data warehousing solutions based on Amazon Redshift since 2016. We help companies integrate the Amazon Redshift cloud data warehouse service into their analytics environment and achieve maximum ROI.
With Amazon Redshift as a core component of an analytics solution, companies realize major financial outcomes in the following areas:
Amazon Redshift allows rapidly provisioning the required infrastructure and ensures constant availability with automatic continuous data replication and backups, etc., which means less unplanned DWH downtime and up to 16% increased productivity of business users*.
Amazon Redshift requires up to 60%* less IT staff time to deploy, administer and support than legacy solutions due to the automation of infrastructure provisioning and administrative tasks, such as backups, replication, and patching, which allows IT teams focus on high-value tasks.
With Amazon Redshift, you eliminate substantial upfront investments for the physical infrastructure deployment, upgrade and maintenance. Additionally, there is no risk of data warehouse overprovisioning thanks to pay-as-you-go pricing models and advanced data compression capabilities.
Amazon Redshift pricing depends on the following factors:
- The node type.
- The number of nodes in the cluster.
- The region where the node cluster is physically located.
- The pricing option – on-demand or reserved instance pricing.
- Additional services (Redshift Spectrum, etc.).
Reserved instance pricing
The prices are relevant to the US East (N. Virginia) data center region and may differ for other data centers.
Managed storage pricing (for RA3 node types for both pricing options): $0.024/GB/month.
Redshift Spectrum pricing: $5.00/terabyte of data scanned + S3 rates.