From the course: Amazon Web Services: Data Services
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Explore AWS Athena - Amazon Web Services (AWS) Tutorial
From the course: Amazon Web Services: Data Services
Explore AWS Athena
- [Instructor] Let's take a look at Athena. If we click on the tutorial, the tutorial allows us to create a table for ELB, or Elastic Load Balancer Data, logs basically, using Athena. And it tells us that Athena is an interactive query service that allows us to query data from S3 without the need for clusters or data warehouses. I'm going to click Next, and it tells me to query the ELB log files. I need to define a corresponding table in Athena. This is metadata that I'm defining over file-based data that's stored in S3. This takes me to the add table wizard. And I've already done this one time, so I'm just going to click through the steps pretty quickly, but I can create a database here, and then I can specify the table name, and here's the input data. You can see it here, it's publicly available data. Actually, I'll probably just do it again here. I'll create a new one. And I'll it fridayDemo. And the table name is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
(Locked)
Understand a data lake pattern with AWS Lake Formation4m 23s
-
(Locked)
Explore AWS Athena3m 11s
-
(Locked)
Explore AWS Glue Data Catalog and Crawlers4m 10s
-
(Locked)
Use AWS Glue for ETL5m 32s
-
(Locked)
Explore a data lake pattern with AWS Lake Formation7m 8s
-
(Locked)
Scenario: Build for the Internet of Things with Hadoop6m 20s
-
(Locked)
-