Browsed by
Tag: #aws

Querying CloudTrail Logs from a centralized S3 Location using Athena

Querying CloudTrail Logs from a centralized S3 Location using Athena

Hello, it’s been some time since my last blog post. Today, I want to discuss the process of querying AWS CloudTrail logs stored in a centralized S3 bucket using AWS Athena. But before diving into the topic, let’s briefly introduce AWS CloudTrail and AWS Athena. AWS CloudTrail is a service that provides governance, compliance, and auditing capabilities for your AWS account. It records all user actions performed on AWS services and resources as events. By aggregating logs from multiple accounts,…

Read More Read More

Covid-19 Analysis with BigData Applications – Part 3

Covid-19 Analysis with BigData Applications – Part 3

Hi there! If you’ve been following these blog series, we are looking at a BigData project to analyze Covid-19 data. So far, we have looked at the overall architecture and ETL Spark jobs. In this post, let’s look the scheduler component (Lambda function) in this workflow. The main reason I’m using Lambda here is due to its serverless nature and native integration with other AWS services. For example, we could trigger it via a CloudWatch scheduled rule in regular basis…

Read More Read More

Covid-19 Analysis with BigData Applications – Part 2

Covid-19 Analysis with BigData Applications – Part 2

Hi again! On this post, I’ll explain on the second two ETL jobs: first one to process the Twitter data related to Covid-19 and second one will combine the data from previous two ETL jobs. As we have already covered the basic EMR concept earlier, I’ll directly get into the explanation of what is being done in these task. For ETL2, I’m creating a Hive table beforehand because this Twitter data is in semi-colon delimited format and isn’t easily parsed…

Read More Read More

AWS – How I Migrated This WordPress Site to AWS Hosting

AWS – How I Migrated This WordPress Site to AWS Hosting

Little ago, I posted that I was going to migrate this blogging site to Amazon Web Services (AWS). Now that I’ve already completed the migration, I thought it’ll be worth sharing my migration procedures because there might be people who would like to do the similar task. In this post, I’m going to cover how I performed the backup and export of my content from existing site and then, configured it in AWS environment. So, let’s begin. Backup an Old Site If you haven’t…

Read More Read More