LuukforLuuk's AWS engineering blogcloudengineer.hashnode.net·Dec 1, 2022Re:Invent 2022 day 3 - Analyze data faster with spark notebooks in Amazon AthenaData analytics is getting more and more accessible! If you want to quickly analyze datasets, Amazon Athena has always been a very easy tool because it requires very little setup. Simply select your database and write your SQL query and you can run an...Discuss·2 likes·39 readsaws athena
kapil GargforKapil's blogkapilg.hashnode.net·Aug 20, 2020How to process nested arrays in json with AthenaSuppose you are writing an application for a library. Instead of storing book inventory in traditional db, you decided to use s3. Each book record is converted to json, stringified, written to a file and stored in S3 as an object. To read this, you c...Discuss·26 readsaws athena
Johannes KoningsforJohannes Konings' Blogjohanneskonings.hashnode.net·Oct 26, 2021Example how to analyze DynamoDB item changes with Kinesis and Athena created with CDKThis is the same like described here. To bootstrap the project run this command: cdk init app --language typescriptFurther information are here All the services are in this file. Updates 2022-09-11: Add prefix for kinesis data firehose S3 destination...Discuss·69 readsAnalyze DynamoDB dataAWS
Vu DaoforVu Daovumdao.hashnode.net·Feb 25, 2023AWS Athena Query WAF logsAbstract Querying AWS WAF Logs - AWS WAF logs include information about the traffic that is analyzed by your web ACL, such as the time that AWS WAF received the request from your AWS resource, detailed information about the request, and the action f...DiscussAWS
Laurynas TumosaforAWS For Humansawsforhumans.hashnode.net·Feb 22, 2023Quering AWS ALB Access Logs using AthenaIntroduction to AWS ALB Access Logs AWS Application Load Balancer (ALB) is a managed service that helps you distribute incoming traffic to multiple targets, such as EC2 instances, containers, or Kubernetes pods. ALB generates access logs that provide...DiscussAWS
Lee Nattressfor3t Engineering Blogleenattress3t.hashnode.net·Feb 1, 2023Golden Hammer Part 1 - Which AWS Database?Have you ever heard of the "Golden Hammer"? No, it's not a tool made of gold (although that would be quite the showstopper in a handyman's toolkit). It's a term used in the software development world to describe a situation we've all probably experie...Discuss·63 readsAWS
Abhay SinghforAbhay Singhabhaysingh.hashnode.net·Jan 15, 2023Top 20 AWS Athena interview Question and answerWhat is Amazon Athena? Answer: Amazon Athena is a serverless, interactive query service that allows you to analyze data in Amazon S3 using SQL. How does Amazon Athena work? Answer: Amazon Athena uses Presto, an open-source distributed SQL query engin...DiscussTutorial
Abhay SinghforAbhay Singhabhaysingh.hashnode.net·Jan 15, 2023Top 20 AWS Athena interview Question and answerWhat is Amazon Athena? Answer: Amazon Athena is a serverless, interactive query service that allows you to analyze data in Amazon S3 using SQL. How does Amazon Athena work? Answer: Amazon Athena uses Presto, an open-source distributed SQL query engin...DiscussTutorial
Raghuveer SriramanforRaghuveer's blogrgvr-1668638136909.hashnode.net·Dec 18, 2022Automatically add partitions in AthenaUsing S3 and Athena is great for data storage and retrieval using queries. But when I first started using it, one common problem that came up fairly quickly is: How can I add new partitions automatically? The issue was this: Partitioned data was gett...Discuss·110 readsAWS
LuukforLuuk's AWS engineering blogcloudengineer.hashnode.net·Dec 1, 2022Re:Invent 2022 day 3 - Analyze data faster with spark notebooks in Amazon AthenaData analytics is getting more and more accessible! If you want to quickly analyze datasets, Amazon Athena has always been a very easy tool because it requires very little setup. Simply select your database and write your SQL query and you can run an...Discuss·2 likes·39 readsaws athena
Johannes KoningsforJohannes Konings' Blogjohanneskonings.hashnode.net·Oct 3, 2022Example how to trigger a Dynamodb export and create an Athena saved query with CDKIn this post is described how to get the data to analyze the changes in the dynamodb data. This post describes how to (semi) automate the export of the dynamodb table data and analyze it with Athena. This post describes how you can do that manually. ...DiscussAnalyze DynamoDB dataAWS
Johannes KoningsforJohannes Konings' Blogjohanneskonings.hashnode.net·Aug 22, 2022Example how to create Athena saved queries with CDKIn this post is a example of a Athena query to get the the current data of the DynamoDb table. This post explains how to provide this query with CDK as a saved query in Athena to have the query stored “nearby” the editor and that the query fits to th...Discuss·28 readsAnalyze DynamoDB dataAWS
James ShelbourneforJames Shelbourne's Blogjashelb90.hashnode.net·Aug 18, 2022Athena - Working with JSONIntroduction If we are using Athena and consume source data that we have no control over and which varies in it's schema (perhaps event data from multiple sources providing unique information), then we need to provide a table that is flexible enough ...Discuss·48 readsaws athena
