Amazon Redshift – Your Petabyte-Scale Cloud Data Warehouse
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.
Automated infrastructure provisioning
Allows deploying DWH in a few clicks.
Data integration with ETL/ELT
Quick processing of data of various volumes and types.
High availability and fault tolerance
Automated backups and continuous cluster health monitoring.
Flexible data querying with SQL (including big data).
Native spatial data processing
Allows integrating spatial data into analytical queries.
Integration with Amazon S3
Querying data lake using SQL with Redshift Spectrum.
Federated queries support
Running queries on live data across the data warehouse, data lake, operational databases with no complex ETL jobs.
Native integrations with the AWS ecosystem
Integrations with third-party tools
Enhancing Amazon Redshift with the industry-leading tools for loading, transforming, analyzing and visualizing data (Power BI, Tableau, Informatica, Qlik, Talend Cloud, etc.)
Accommodation to intensive workloads
Quick scaling of storage and compute resources.
Massively parallel processing
Coordinated query processing by multiple computer processors.
Delivering precomputed/cached results for speeding up queries.
Optimized data storage
Speeding up query performance with columnar data storage, data compression, zone maps, compression encoding, etc.
Machine learning capabilities
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.
Row and column level security
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*.
IT staff efficiency
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.
IT infrastructure costs
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.