You're reading from AWS Certified Cloud Practitioner Exam Guide Build your cloud computing knowledge and build your skills as an AWS Certified Cloud Practitioner (CLF-C01)

Product type Paperback

Published in Jan 2022

Publisher Packt

ISBN-13 9781801075930

Length 630 pages

Edition 1st Edition

Tools

AWS

Concepts

Cloud Computing

Author (1):

Rajesh Daswani

View More author details

Table of Contents (23) Chapters

Preface

1. Section 1: Cloud Concepts

2. Chapter 1: What Is Cloud Computing? FREE CHAPTER

3. Chapter 2: Introduction to AWS and the Global Infrastructure

4. Chapter 3: Exploring AWS Accounts, Multi-Account Strategy, and AWS Organizations

5. Section 2: AWS Technologies

6. Chapter 4: Identity and Access Management

7. Chapter 5: Amazon Simple Storage Service (S3)

8. Chapter 6: AWS Networking Services – VPCs, Route53, and CloudFront

9. Chapter 7: AWS Compute Services

10. Chapter 8: AWS Database Services

11. Chapter 9: High Availability and Elasticity on AWS

12. Chapter 10: Application Integration Services

13. Chapter 11: Analytics on AWS

14. Chapter 12: Automation and Deployment on AWS

15. Chapter 13: Management and Governance on AWS

16. Section 3: AWS Security

17. Chapter 14: Implementing Security in AWS

18. Section 4: Billing and Pricing

19. Chapter 15: Billing and Pricing

20. Chapter 16: Mock Tests

21. Answers

22. Other Books You May Enjoy

Learning how to query data stored in Amazon S3 with Amazon Athena

Businesses store vast amounts of data in repositories such as Amazon S3. A lot of this data is not necessarily being hosted on regular Amazon RDS or NoSQL databases. In many cases, this is because the dataset is not being regularly updated and queried. Previously, even if you wanted to perform ad hoc queries or analysis against some of that data, you would need to ingest it into a database and then run your queries against the database.

Amazon Athena is a fully managed serverless solution that allows you to interactively query and analyze data directly in Amazon S3 using standard SQL. There is no infrastructure to provision, and you only pay for the queries you run.

Amazon Athena uses Presto, which is an open source SQL query engine that's designed to allow you to perform ad hoc analysis. You can use standard ANSI SQL, which provides full support for large joins, window functions, and arrays.

Data can...