You're reading from AWS for Solutions Architects Design your cloud infrastructure by implementing DevOps, containers, and Amazon Web Services

Product type Paperback

Published in Feb 2021

Publisher Packt

ISBN-13 9781789539233

Length 454 pages

Edition 1st Edition

Tools

AWS

Concepts

Cloud Computing

Table of Contents (20) Chapters

Preface

1. Section 1: Exploring AWS

2. Chapter 1: Understanding AWS Cloud Principles and Key Characteristics FREE CHAPTER

3. Chapter 2: Leveraging the Cloud for Digital Transformation

4. Section 2: AWS Service Offerings and Use Cases

5. Chapter 3: Storage in AWS – Choosing the Right Tool for the Job

6. Chapter 4: Harnessing the Power of Cloud Computing

7. Chapter 5: Selecting the Right Database Service

8. Chapter 6: Amazon Athena – Combining the Simplicity of Files with the Power of SQL

9. Chapter 7: AWS Glue – Extracting, Transforming, and Loading Data the Simple Way

10. Chapter 8: Best Practices for Application Security, Identity, and Compliance

11. Section 3: Applying Architectural Patterns and Reference Architectures

12. Chapter 9: Serverless and Container Patterns

13. Chapter 10: Microservice and Event-Driven Architectures

14. Chapter 11: Domain-Driven Design

15. Chapter 12: Data Lake Patterns – Integrating Your Data across the Enterprise

16. Chapter 13: Availability, Reliability, and Scalability Patterns

17. Section 4: Hands-On Labs

18. Chapter 14: Hands-On Lab and Use Case

19. Other Books You May Enjoy

Leave a review - let other readers know what you think

Reviewing Amazon Athena's APIs

One of the features that make Amazon Athena so powerful is the fact that it uses SQL as the access language. You can connect to Amazon Athena using a JDBC driver. JDBC driver technology has been around for decades and is the gold standard when it comes to accessing SQL data sources. With Amazon Athena, any set of files stored in Amazon S3 becomes a de facto database.

Additionally, with Amazon Athena Federated Query, you can use the same SQL language to combine disparate data sources and perform joins between heterogeneous repositories, for example, a join between an Oracle table and a JSON file stored in an S3 bucket. The fact that these tables are not of the same type will be transparent to Amazon Athena users and they will all look the same to them in the AWS Glue Data Catalog, which Amazon Athena uses.