Welcome!

News Feed Item

AWS Launches Amazon Athena

Amazon Web Services, Inc. (AWS), an Amazon.com company (NASDAQ: AMZN), today announced Amazon Athena, a serverless query service that makes it easy to analyze data directly in Amazon Simple Storage Service (Amazon S3) using standard SQL. With a few clicks in the AWS Management Console, customers can point Amazon Athena at their data stored in Amazon S3 and begin using standard SQL to run queries and get results in seconds. With Amazon Athena there are no clusters to manage and tune, no infrastructure to setup or manage, and customers pay only for the queries they run. Amazon Athena scales automatically – executing queries in parallel – so results are fast, even with large datasets and complex queries. To get started with Amazon Athena, visit https://aws.amazon.com/athena.

AWS analytics services like Amazon Redshift and Amazon EMR have made petabyte-scale analytics accessible to companies of all sizes. With Amazon Redshift, customers can perform complex queries on massive collections of structured data and get superfast performance. For unstructured data, Amazon EMR makes it fast and cost-effective to process and analyze vast amounts of data across dynamically scalable clusters using popular distributed frameworks like Apache Spark, Presto, Hive, and Pig. While these services are scalable and powerful enough to handle the largest and most complex big data applications, many customers also want to be able to very quickly run queries on data stored in Amazon S3 (e.g. web logs, clickstreams, and raw event files) without having to spin up, configure, and manage a Hadoop cluster or a data warehouse. Now, with Amazon Athena, analyzing data stored in Amazon S3 is as simple as writing SQL queries. Amazon Athena uses Presto with full standard SQL support and works with a variety of standard data formats, including CSV, JSON, ORC, and Parquet. And, while Amazon Athena is ideal for quick, ad-hoc querying and integrates with Amazon QuickSight for easy visualization, it can also handle complex analysis, including large joins, window functions, and arrays. Because Amazon Athena executes queries using compute resources in multiple Availability Zones and uses Amazon S3 as the underlying data store, it is highly available and durable with data redundantly stored across multiple facilities and multiple devices in each facility.

“Over the past few years, AWS has built a comprehensive set of big data services that customers use to do everything from real-time analytics on streaming data, to petabyte-scale data warehousing, or Spark and Hadoop jobs – and it’s all fast, scalable, and cost-effective,” said Raju Gulabani, Vice President, Databases, Analytics, and AI, AWS. “For hundreds of thousands of customers, Amazon S3 is their primary data store – holding billions to trillions of objects. Customers have frequently asked us whether we could make it easy for anyone to run queries on their data in Amazon S3 without having to worry about provisioning or managing servers and clusters. Now they can. There is absolutely zero admin with Amazon Athena – anyone who can write a SQL query can analyze their data in Amazon S3. Amazon QuickSight and Amazon Athena are tightly integrated, enabling customers to visualize their Amazon Athena query results without even writing a SQL query.”

“We are long time customers of AWS, and use services like Amazon Redshift and Amazon EMR to support and power analytics across the company,” said Paul Cheesbrough, Chief Technology Officer, News Corp. “We received early access to Amazon Athena, and it has proven to be fast, easy to use, and cost effective. We've had great feedback from our teams of engineers and analysts, especially on Amazon Athena’s ability to query directly from Amazon S3, and we're excited about where we go next with the service.”

LiveIntent, a platform for people-based marketing and advertising focused on the email channel, helps over 1,100 brands deliver marketing and advertising to 145 million people in emails sent by 1,300 top Publishers every month. “The LiveIntent platform collects and processes hundreds of millions of events per day. We are continuously challenging ourselves to build and extend the platform to provide faster and cheaper access to data, which in turn translates to better and faster insights for our customers,” said Eric Raab, Executive Vice President of Engineering, LiveIntent. “We found Amazon Athena to be faster and cheaper than any other solution we evaluated and decided utilize its capabilities right away. We really like that Amazon Athena has zero administration, and that we can query a multitude of formats directly from Amazon S3 with no loading required.”

DataXu helps marketers understand how marketing investments can lead to profitable customer relationships using data. “We process 3M+ bid requests per second, which results in a total of 3PB of incoming data every day. Even with compression and reduction, this results in 180+ Terabytes of logs per day,” said Yekesa Kosuru, Vice President, Engineering, DataXu. “We started using Amazon Athena as soon as we heard about it and are loving its simplicity, speed, and pay-per-query pricing model. Amazon Athena provides us with the ability to query our entire data set stored on Amazon S3, without the need to manage infrastructure. Because there’s nothing to manage and we only pay per query, we’re actively deploying Amazon Athena throughout the company.”

Gunosy is a leading Japanese provider of news curation apps. “We began using Amazon Athena as soon as we could and were impressed that even in preview Amazon Athena was faster than the system we had been using – even though it’s querying data directly from Amazon S3,” said Yosuke Abe, Data Scientist, Gunosy. “We're actively migrating workloads to AWS so we can put Amazon Athena at the core of our analytics platform.”

Inrix is a leading provider of real-time traffic intelligence for enterprises, public sector, and media. “At INRIX we ingest terabytes of road network and movement data on a daily basis and run hundreds of Amazon EMR data pipelines to process it. We use Amazon S3 as a repository for our un-processed, in-process, and processed datasets. Our data scientists need to slice, dice, and analyze this data to build mathematical models of predictive analytics on road networks. Our data engineers need the ability to drill down from processed data to in-process data for monitoring and debugging data quality issues,” said Harsh Shah, Group Engineering Manager, Inrix. “We jumped at the opportunity to try Amazon Athena and loved the speed, ease of use, and flexibility offered by Amazon Athena. With Amazon Athena, any of our developers can query all of our data stored on Amazon S3 using SQL, without worrying about infrastructure or knowledge of big data processing systems. Amazon Athena has enabled us to quickly turn Amazon S3 into our data lake.”

Japan Taxi, a transportation app, has two million active users every month. “The ability to put data into Amazon S3 and query it just using standard SQL with Amazon Athena is incredible,” said Kazuhiri Iwata, Chief Technology Officer, Japan Taxi. “With Amazon Athena, we don’t have to load the data since the service can query the data in place. Now, any of our developers can query data at its most granular resolution, at low costs – enabling us to give everyone who needs it easy access to our data. Because Amazon Athena uses open source formats, we can also use other solutions like Amazon EMR on the same data, making interoperability easy. And, because Amazon Athena requires no administration, we were able to get started immediately.”

mParticle allows mobile app developers to collect and make sense of their data. “At mParticle we collect and process large amounts of data. We want all of our customers to be able to process raw data with simple languages such as SQL,” said Michael Katz, Chief Technology Officer, mParticle. “We jumped on Amazon Athena as soon as we heard about it, as the ability to quickly analyze large amounts of data using standard SQL appealed to us. With Amazon Athena, we got started immediately, paid by the query, and queries ran quickly. We liked the ANSI-SQL compatibility and that it can query both text and columnar formats.”

Nasdaq’s technology powers more than 70 marketplaces in 50 countries, and 1 in 10 of the world’s securities transactions. “Built on a vision of innovation and a heritage of disruption, we are always looking for new ways to improve efficiencies and gain new insights across business areas within all of our markets. Given that data is critical to the success of our business, we are always interested in new tools to analyze the data we have stored in Amazon Redshift, Amazon S3, and other sources,” said Nate Sammons, Principal Architect, Nasdaq, Inc. “We wanted to extend our Amazon Redshift data warehouse and build a secure, cost effective long term data store. We chose Amazon S3 for storage and Presto as part of the query and analytics system because of its ANSI-SQL compatibility and fast performance. We expect Amazon Athena will help us take that idea even further by eliminating the need for clusters and allowing all of our analysts to query data in Amazon S3 at fast speeds.”

JW Player, one of the world’s most popular video player and a leading digital and mobile video solutions company, is live on more than 2 million sites across all devices — OTT, phones, tablets, and desktops — with more than 1.3 billion unique monthly views. “We use a combination of platforms to power the JW Analytics Dashboard, which provides analytics to measure content performance across large data sets. We regularly ingest 4+ billion events per day and are always looking for solutions that simplify processing large data sets, while reducing cost and complexity,” said Rick Okin, Vice President of Engineering, JW Player. “Amazon Athena provides us with an easy to use, fast and cost-effective solution with zero-administration. We love the fact that we can just put our data in S3, use open formats such as Apache Parquet to allow interoperability with the rest of our stack, and run SQL queries, without worrying about clusters or data warehouses.”

Tableau helps people see and understand data. “Our mission is to put data in the hands of as many people as possible so they can act on it and have an impact on the world around them,” said Andrew Beers, Chief Development Officer, Tableau. “We’ve partnered with AWS for a long time and have native integrations with Amazon Redshift, Amazon EMR, and Amazon RDS. We’re excited to announce support for Amazon Athena as well. Using Tableau and Amazon Athena together, customers can visualize all their data in Amazon S3 interactively, cost-effectively, and with no infrastructure to manage.”

Customers can start using Amazon Athena using the AWS Management Console. Amazon Athena is currently available in the US East (N. Virginia) and US West (Oregon) Regions, and will expand to additional Regions in the coming months.

About Amazon Web Services
For 10 years, Amazon Web Services has been the world’s most comprehensive and broadly adopted cloud platform. AWS offers over 70 fully featured services for compute, storage, databases, analytics, mobile, Internet of Things (IoT) and enterprise applications from 38 Availability Zones (AZs) across 14 geographic regions in the U.S., Australia, Brazil, China, Germany, Ireland, Japan, Korea, Singapore, and India. AWS services are trusted by more than a million active customers around the world -- including the fastest growing startups, largest enterprises, and leading government agencies -- to power their infrastructure, make them more agile, and lower costs. To learn more about AWS, visit http://aws.amazon.com.

About Amazon
Amazon is guided by four principles: customer obsession rather than competitor focus, passion for invention, commitment to operational excellence, and long-term thinking. Customer reviews, 1-Click shopping, personalized recommendations, Prime, Fulfillment by Amazon, AWS, Kindle Direct Publishing, Kindle, Fire tablets, Fire TV, Amazon Echo, and Alexa are some of the products and services pioneered by Amazon. For more information, visit www.amazon.com/about.

More Stories By Business Wire

Copyright © 2009 Business Wire. All rights reserved. Republication or redistribution of Business Wire content is expressly prohibited without the prior written consent of Business Wire. Business Wire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.

Latest Stories
SYS-CON Events announced today that Enzu will exhibit at SYS-CON's 21st Int\ernational Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to focus on the core of their ...
Join us at Cloud Expo June 6-8 to find out how to securely connect your cloud app to any cloud or on-premises data source – without complex firewall changes. More users are demanding access to on-premises data from their cloud applications. It’s no longer a “nice-to-have” but an important differentiator that drives competitive advantages. It’s the new “must have” in the hybrid era. Users want capabilities that give them a unified view of the data to get closer to customers and grow business. The...
Multiple data types are pouring into IoT deployments. Data is coming in small packages as well as enormous files and data streams of many sizes. Widespread use of mobile devices adds to the total. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists looked at the tools and environments that are being put to use in IoT deployments, as well as the team skills a modern enterprise IT shop needs to keep things running, get a handle on all this data, and deliver...
Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more business becomes digital the more stakeholders are interested in this data including how it relates to business. Some of these people have never used a monitoring tool before. They have a question on their mind like “How is my application doing” but no id...
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected in a way that makes the public cloud a non-starter. You’re looking at private cloud solutions based on hyperconverged infrastructure, but you’re concerned with the limits inherent in those technologies.
In his session at @ThingsExpo, Eric Lachapelle, CEO of the Professional Evaluation and Certification Board (PECB), provided an overview of various initiatives to certify the security of connected devices and future trends in ensuring public trust of IoT. Eric Lachapelle is the Chief Executive Officer of the Professional Evaluation and Certification Board (PECB), an international certification body. His role is to help companies and individuals to achieve professional, accredited and worldwide re...
Both SaaS vendors and SaaS buyers are going “all-in” to hyperscale IaaS platforms such as AWS, which is disrupting the SaaS value proposition. Why should the enterprise SaaS consumer pay for the SaaS service if their data is resident in adjacent AWS S3 buckets? If both SaaS sellers and buyers are using the same cloud tools, automation and pay-per-transaction model offered by IaaS platforms, then why not host the “shrink-wrapped” software in the customers’ cloud? Further, serverless computing, cl...
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...
IoT solutions exploit operational data generated by Internet-connected smart “things” for the purpose of gaining operational insight and producing “better outcomes” (for example, create new business models, eliminate unscheduled maintenance, etc.). The explosive proliferation of IoT solutions will result in an exponential growth in the volume of IoT data, precipitating significant Information Governance issues: who owns the IoT data, what are the rights/duties of IoT solutions adopters towards t...
It is ironic, but perhaps not unexpected, that many organizations who want the benefits of using an Agile approach to deliver software use a waterfall approach to adopting Agile practices: they form plans, they set milestones, and they measure progress by how many teams they have engaged. Old habits die hard, but like most waterfall software projects, most waterfall-style Agile adoption efforts fail to produce the results desired. The problem is that to get the results they want, they have to ch...
With the introduction of IoT and Smart Living in every aspect of our lives, one question has become relevant: What are the security implications? To answer this, first we have to look and explore the security models of the technologies that IoT is founded upon. In his session at @ThingsExpo, Nevi Kaja, a Research Engineer at Ford Motor Company, discussed some of the security challenges of the IoT infrastructure and related how these aspects impact Smart Living. The material was delivered interac...
Wooed by the promise of faster innovation, lower TCO, and greater agility, businesses of every shape and size have embraced the cloud at every layer of the IT stack – from apps to file sharing to infrastructure. The typical organization currently uses more than a dozen sanctioned cloud apps and will shift more than half of all workloads to the cloud by 2018. Such cloud investments have delivered measurable benefits. But they’ve also resulted in some unintended side-effects: complexity and risk. ...
The taxi industry never saw Uber coming. Startups are a threat to incumbents like never before, and a major enabler for startups is that they are instantly “cloud ready.” If innovation moves at the pace of IT, then your company is in trouble. Why? Because your data center will not keep up with frenetic pace AWS, Microsoft and Google are rolling out new capabilities. In his session at 20th Cloud Expo, Don Browning, VP of Cloud Architecture at Turner, posited that disruption is inevitable for comp...
In 2014, Amazon announced a new form of compute called Lambda. We didn't know it at the time, but this represented a fundamental shift in what we expect from cloud computing. Now, all of the major cloud computing vendors want to take part in this disruptive technology. In his session at 20th Cloud Expo, Doug Vanderweide, an instructor at Linux Academy, discussed why major players like AWS, Microsoft Azure, IBM Bluemix, and Google Cloud Platform are all trying to sidestep VMs and containers wit...
While DevOps most critically and famously fosters collaboration, communication, and integration through cultural change, culture is more of an output than an input. In order to actively drive cultural evolution, organizations must make substantial organizational and process changes, and adopt new technologies, to encourage a DevOps culture. Moderated by Andi Mann, panelists discussed how to balance these three pillars of DevOps, where to focus attention (and resources), where organizations might...