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 SQL query on S3

Query Athena using SQL query on S3 - Amazon Web Services (AWS) Tutorial

From the course: Amazon Web Services: Data Analytics

Start my 1-month free trial

Query Athena using SQL query on S3

“

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

Contents