From the course: Amazon Web Services: Data Analytics

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Query Athena using the AWS CLI

Query Athena using the AWS CLI - Amazon Web Services (AWS) Tutorial

From the course: Amazon Web Services: Data Analytics

Start my 1-month free trial

Query Athena using the AWS CLI

“

- [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…

Contents