Skip to Content
Data Science on AWS
book

Data Science on AWS

by Chris Fregly, Antje Barth
April 2021
Intermediate to advanced
521 pages
13h 33m
English
O'Reilly Media, Inc.
Content preview from Data Science on AWS

Chapter 5. Explore the Dataset

In the previous chapter, we demonstrated how to ingest data into the cloud with Amazon Athena and Redshift. Amazon Athena offers ad hoc, serverless SQL queries for data in S3 without needing to set up, scale, and manage any clusters. Amazon Redshift provides the fastest query performance for enterprise reporting and business intelligence workloads—particularly those involving complex SQL with multiple joins and subqueries across many data sources, including relational databases and flat files. We created a data-catalog mapping for our S3-based data lake in S3 using AWS Glue Catalog. We ran ad hoc queries on our data lake with Athena. And we ran queries on our data warehouse with Amazon Redshift.

We also had a first peek into our dataset. As we’ve learned, the Amazon Customer Reviews Dataset consists of more than 150+ million of those customer reviews of products across 43 different product categories on the Amazon.com website from 1995 until 2015. The dataset contains the actual customer reviews text together with additional metadata. It comes in two formats: row-based tab-separated values (TSV) and column-based Apache Parquet.

In this chapter, we will use the SageMaker Studio integrated development environment (IDE) as our main workspace for data analysis and the model development life cycle. SageMaker Studio provides fully managed Jupyter Notebook servers. With just a couple of clicks, we can provision the SageMaker Studio IDE and start using Jupyter ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Data Engineering with AWS

Data Engineering with AWS

Gareth Eagar
Generative AI on AWS

Generative AI on AWS

Chris Fregly, Antje Barth, Shelbee Eigenbrode

Publisher Resources

ISBN: 9781492079385Errata Page