Book Image

AWS for Solutions Architects

By : Alberto Artasanchez
3 (1)
Book Image

AWS for Solutions Architects

3 (1)
By: Alberto Artasanchez

Overview of this book

One of the most popular cloud platforms in the world, Amazon Web Services (AWS) offers hundreds of services with thousands of features to help you build scalable cloud solutions; however, it can be overwhelming to navigate the vast number of services and decide which ones best suit your requirements. Whether you are an application architect, enterprise architect, developer, or operations engineer, this book will take you through AWS architectural patterns and guide you in selecting the most appropriate services for your projects. AWS for Solutions Architects is a comprehensive guide that covers the essential concepts that you need to know for designing well-architected AWS solutions that solve the challenges organizations face daily. You'll get to grips with AWS architectural principles and patterns by implementing best practices and recommended techniques for real-world use cases. The book will show you how to enhance operational efficiency, security, reliability, performance, and cost-effectiveness using real-world examples. By the end of this AWS book, you'll have gained a clear understanding of how to design AWS architectures using the most appropriate services to meet your organization's technological and business requirements.
Table of Contents (20 chapters)
1
Section 1: Exploring AWS
4
Section 2: AWS Service Offerings and Use Cases
11
Section 3: Applying Architectural Patterns and Reference Architectures
17
Section 4: Hands-On Labs

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.