Querying your data lake in AWS with Amazon Athena
Water, water everywhere, and not a drop to drink… This may be the feeling you get in today's enterprise environments. We are producing data at an exponential rate, but it is sometimes difficult to find a way to analyze this data and gain insights from it. Some of the data that we are generating at a prodigious rate is of the following types:
- Application logging
- Clickstream data
- Surveillance video
- Smart and IoT devices
- Commercial transactions
Often, this data is captured without analysis or is at least not analyzed to the fullest extent. Analyzing this data properly can translate into the following:
- Increased sales
- Cross-selling opportunities
- Lower operational and hardware infrastructure costs
- Avoiding downtime and errors before they occur
- Serving customer bases more efficiently
Previously, one stumbling block to analyzing this data was that much of this information resides in flat files. To analyze them, we had to...