| Service | Purpose | Key Highlights |
|---|---|---|
| Amazon Athena | Serverless SQL querying directly on data lakes | Query data in Amazon S3 using standard SQL. Pay only for scanned data. Ideal for ad-hoc exploration, data validation, or feeding BI dashboards. Integrates with Glue Catalog for schema metadata. |
| Amazon Redshift | Cloud data warehouse for analytics | MPP-based (massively parallel) SQL engine optimized for analytical workloads. Supports columnar storage, compression, and federated queries to S3 via Redshift Spectrum. |
| Amazon QuickSight | Visualization & BI layer | Serverless, browser-based BI platform for dashboards, ML-powered insights, and natural-language queries (Q feature). Integrates directly with Redshift, Athena, RDS, or S3. |
| AWS Lake Formation | Unified data governance & access control | Provides fine-grained permissions, catalog integration, and secure access policies across Glue, Athena, and Redshift. Ensures "who sees what" is centrally managed. |
Created
November 5, 2025 08:48
-
-
Save Anshuman-02905/624d299133fdd728f8b7a4fda0a8f96e to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment