Query AWS S3 ALB Access Logs with Amazon Athena

preview_player
Показать описание
In this #AWS video tutorial, you'll learn how to use Amazon Athena to run SQL queries against AWS Elastic Load Balancer access logs in an Amazon S3 bucket.

Athena allows us to run SQL queries on unstructured data. In this demonstration, you'll see how to connect this solution together so you can query your log files generated by an AWS Application Load Balancer (ALB).


_______________________

At Digital Cloud Training, our mission is to help you succeed in your #cloud career.

👉 Check out our popular training options for #AmazonWebServices, including

  1. Digital Cloud Training
  2. AWS
  3. Amazon Web Services
  4. AWS Amazon
  5. AWS Certified
  6. AWS Training
Рекомендации по теме
Query AWS ALB 0:06:13

Query AWS ALB Access Logs in Amazon S3 with Athena

Query AWS S3 0:09:13

Query AWS S3 ALB Access Logs with Amazon Athena

Amazon Athena to 0:11:43

Amazon Athena to Query AWS S3 Data

How do I 0:05:43

How do I analyze my Amazon S3 server access logs using Amazon Athena?

How to query 0:08:11

How to query S3 data from Athena using SQL | AWS Athena Hands On Tutorial | Create Athena Tables

AWS ALB EC2 0:26:00

AWS ALB EC2 S3 ATHENA (AWS ALB access logs to s3 and then analyse by Athena)

AWS Athena | 0:10:06

AWS Athena | How to Query S3 Access Logs to Athena | AWS Tutorial for Beginners

AWS S3 - 0:08:46

AWS S3 - Access Logs | Amazon S3 - Server Access Logging | AWS Tutorial | Easy Explanation

Amazon Athena Query 0:14:34

Amazon Athena Query | S3 | JSON | Amazon Athena Query for Amazon S3 Bucket JSON Raw Files

Setup AWS S3 0:02:47

Setup AWS S3 Bucket Access logs

Let's Setup AWS 0:06:36

Let's Setup AWS S3 Bucket Access Log

AWS S3 Tutorial 0:27:18

AWS S3 Tutorial For Beginners

AWS CloudWatch Logs: 0:02:48

AWS CloudWatch Logs: using search, filter and sort operations.

Querying Data in 0:10:36

Querying Data in S3 with Amazon Athena

AWS S3 Select 0:00:54

AWS S3 Select | Query your S3 data files with SQL | AWS tutorial in 60 seconds (Step By Step)

AWS Pi Week 0:14:55

AWS Pi Week 2021: Demo - Monitor your Amazon S3 inventory & identify sensitive data | AWS Events

AWS ATHENA 2: 0:09:14

AWS ATHENA 2: Save SQL Query Results in an S3 Bucket.

Export logs to 0:01:59

Export logs to Amazon S3 | Beginner | Quick tips | Tutorial

Stream S3 data 0:09:37

Stream S3 data to AWS OpenSearch Index using S3 event triggers

Cross-Account Access to 0:12:20

Cross-Account Access to Amazon S3 | AWS IAM

AWS Tutorials - 0:26:52

AWS Tutorials - Access S3 Data in Amazon Redshift using Redshift Spectrum

Demo: Action Last 0:06:46

Demo: Action Last Accessed for Amazon S3 Management Actions

AWS Big Data 0:24:33

AWS Big Data Analytics | aws Athena query s3 | AWS Athena hands on | AWS glue ETL jobs

How To Apply 0:02:24

How To Apply AWS S3 Bucket Policy | AWS S3 Bucket Public Access

Комментарии
Автор

Thank. I have setup exactly like this and I was able to query until a particular date and then recently I noticed that when querying it doesnot return results since that date(24th May was the last date for which query returns result). I checked s3 and the logs are getting generated for each and every day

DesiAustrianDreams
Автор

This solution is not optimized yet. What if you have TB of log files? Athena will scan all the raw file -> increasing cost and performance. It would be nice if you can do optimization analysis

danghuynguyen