AWS Analytics Services

🔹 AWS Analytics Services

1️⃣ Amazon Redshift

🔸 Service Overview

Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse service used for fast SQL-based analytics on large datasets.

🔸 Key Features

Columnar storage

1.Massively Parallel Processing (MPP)

2.High-performance SQL queries

3.Integration with S3, Glue, QuickSight

4.Redshift Spectrum for querying S3 data

5.Automated backups and scaling

🔸 AWS Category / Cloud Domain

1.Analytics

2.Data Warehousing

🔸 Where It Fits in Cloud / DevOps Lifecycle

1.Data analytics & business intelligence

2.Reporting and decision-making stage

3.Used after data ingestion and ETL processes

🔸 Programming Language / Access Methods

1.SQL

2.AWS Console

3.AWS CLI

4.JDBC / ODBC

5.SDKs (Python, Java, etc.)

🔸 Pricing Model

1.Pay for node type and number of nodes

2.On-demand or Reserved instances

3.Separate charges for storage and Spectrum queries

2️⃣ Amazon Athena

🔸 Service Overview

Amazon Athena is a serverless interactive query service that allows you to analyze data directly in Amazon S3 using standard SQL.

🔸 Key Features

1.Serverless (no infrastructure management)

2.Query data directly from S3

3.Supports structured and semi-structured data

4.Integrates with AWS Glue Data Catalog

5.Fast ad-hoc querying

🔸 AWS Category / Cloud Domain

1.Analytics

2.Serverless Data Query

🔸 Where It Fits in Cloud / DevOps Lifecycle

1.Ad-hoc analysis

2.Log analysis and monitoring

3.Quick insights without ETL

🔸 Programming Language / Access Methods

1.SQL

2.AWS Console

3.AWS CLI

4.SDKs (Python, Java, etc.)

5.JDBC / ODBC

🔸 Pricing Model

1.Pay per query

2.Charged per TB of data scanned

3.No infrastructure or cluster cost

Conclusion

Redshift is best for large-scale analytics and BI workloads.

Athena is best for quick, serverless SQL queries on S3 data.