Use the AWS CLI to query AWS Athena data using scripts.
- [Instructor] So now that we've set up the AWL CLI,…we're going to work with one of our data services, Athena.…And you might remember from an earlier movie…that Athena is a relatively new service…that allows you to do anti-sequel queries…on top of files that are stored in S3,…After you've defined a tabular schema on top of that file.…And we did that in an earlier movie,…and we created this table ELB Logs.…Now as of this recording, the support for the AWS CLI…for Athena does not include all the possible commands.…
And that's 'cause it's a new service.…So you're going to want to check this documentation…when you use the CLI.…The other thing is you're going to need to have…an output bucket, so I've created that here,…so in S3 I've created, and your name could be different,…of course, Run Athena, and you can see…there's nothing in it right now.…And just to show you how we're going to interact.…First we're going to just choose the console…and then we're going to take it out to the CLI.…So I've written a sequel command, here.…
- 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.