Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Data Engineering with AWS - Second Edition

You're reading from  Data Engineering with AWS - Second Edition

Product type Book
Published in Oct 2023
Publisher Packt
ISBN-13 9781804614426
Pages 636 pages
Edition 2nd Edition
Languages
Author (1):
Gareth Eagar Gareth Eagar
Profile icon Gareth Eagar

Table of Contents (24) Chapters

Preface 1. Section 1: AWS Data Engineering Concepts and Trends
2. An Introduction to Data Engineering 3. Data Management Architectures for Analytics 4. The AWS Data Engineer’s Toolkit 5. Data Governance, Security, and Cataloging 6. Section 2: Architecting and Implementing Data Engineering Pipelines and Transformations
7. Architecting Data Engineering Pipelines 8. Ingesting Batch and Streaming Data 9. Transforming Data to Optimize for Analytics 10. Identifying and Enabling Data Consumers 11. A Deeper Dive into Data Marts and Amazon Redshift 12. Orchestrating the Data Pipeline 13. Section 3: The Bigger Picture: Data Analytics, Data Visualization, and Machine Learning
14. Ad Hoc Queries with Amazon Athena 15. Visualizing Data with Amazon QuickSight 16. Enabling Artificial Intelligence and Machine Learning 17. Section 4: Modern Strategies: Open Table Formats, Data Mesh, DataOps, and Preparing for the Real World
18. Building Transactional Data Lakes 19. Implementing a Data Mesh Strategy 20. Building a Modern Data Platform on AWS 21. Wrapping Up the First Part of Your Learning Journey 22. Other Books You May Enjoy
23. Index

Hands-on – creating an Amazon Athena workgroup and configuring Athena settings

In this section, we’re going to create and configure a new Athena workgroup, and set a per query data limit:

  1. Log into AWS Management Console and access the Athena service using this link: https://console.aws.amazon.com/athena.
  2. Expand the left-hand menu and click on Workgroups to access the workgroup management page.

Figure 11.2: Athena Console showing Workgroups

  1. On the workgroup management page, click on Create workgroup and enter the following values for our new workgroup. For the items not listed here, leave the defaults as-is:
    • Workgroup name: Provide a descriptive name for the workgroup, such as datalake-user-sandbox.
    • Description: Optionally, provide a description for this workgroup, such as Sandbox workgroup for new datalake-users.
    • Query result location (in the Query result configuration section): In the hands-on exercises...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime}