You're reading from Modern Data Architecture on AWS A Practical Guide for Building Next-Gen Data Platforms on AWS

Product type Paperback

Published in Aug 2023

Publisher Packt

ISBN-13 9781801813396

Length 420 pages

Edition 1st Edition

Tools

AWS

Concepts

Data Science

Author (1):

Behram Irani

View More author details

Table of Contents (24) Chapters

Preface

1. Part 1: Foundational Data Lake

2. Prologue: The Data and Analytics Journey So Far FREE CHAPTER

3. Chapter 1: Modern Data Architecture on AWS

4. Chapter 2: Scalable Data Lakes

5. Part 2: Purpose-Built Services And Unified Data Access

6. Chapter 3: Batch Data Ingestion

7. Chapter 4: Streaming Data Ingestion

8. Chapter 5: Data Processing

9. Chapter 6: Interactive Analytics

10. Chapter 7: Data Warehousing

11. Chapter 8: Data Sharing

12. Chapter 9: Data Federation

13. Chapter 10: Predictive Analytics

14. Chapter 11: Generative AI

15. Chapter 12: Operational Analytics

16. Chapter 13: Business Intelligence

17. Part 3: Govern, Scale, Optimize And Operationalize

18. Chapter 14: Data Governance

19. Chapter 15: Data Mesh

20. Chapter 16: Performant and Cost-Effective Data Platform

21. Chapter 17: Automate, Operationalize, and Monetize

22. Index

Why subscribe?

23. Other Books You May Enjoy

Data federation using Amazon Redshift

Federated queries can be executed even from inside Redshift, allowing Redshift data to be joined with data from relational data sources such as PostgreSQL and MySQL, either on Amazon RDS or on Amazon Aurora. For certain use cases, it does not make sense to spend time creating an ETL pipeline to load data inside Redshift. Redshift can connect to these sources and distribute the execution of such queries down to the data source itself to improve performance.

The following figure highlights the current data sources that Redshift federated queries can work with. With the federated architecture in place inside Redshift, more source connectors may get added in the future, to expand the ecosystem and broaden the use cases that can be solved with this architecture pattern: