Learn the basics of AWS Athena. Learn how to execute a SQL query on data stored in an S3 bucket.
- [Instructor] So the first service we're going…to look at is Athena and the idea is…that you have data stored in buckets so it's file data…that you want to perform ANSI SQL style queries on top of.…And common use cases for this are log data…or some kind of behavioral data,…so non-transactional, non-mission-critical,…kind of a nice to have,…or wonder what this data contains type of data.…Log data is really the most typical use case for this.…
So why you don't put this in a relational database is…'cause it's cheaper, it's a lot cheaper…to just store it as a file.…A very effective and quick way…to find out if there is useful business information is…to use query techniques that most…of your developers already know, ANSI SQL.…So how does this work?…It seems kind of magical.…How can you do a SQL query on a text file?…Well, there is something in the middle…and that's the schema.…So this schema is defined in a metalanguage…and there's a couple of different metalanguages…and basically this just means a DDL…or data definition type of language…
- Explain the difference between files and databases.
- Identify examples of batching, micro-batching, and streaming.
- Prepare helpful data visualizations with QuickSight.
- Recognize the different types of analytics available in AWS.
- Demonstrate how to set up AWS CLI.
- Describe common analytics architecture patterns.
Skill Level Intermediate
Amazon Web Services for Data Sciencewith Lynn Langit3h 56m Intermediate
1. Analytics on AWS
2. Analytic Services
3. AWS Code Tools for Analytics
4. Advanced Analytics
Next steps1m 20s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.