Amazon Athena

 

 

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 (Simple Storage Service), using standard SQL. Since Athena is serverless, there is no infrastructure to manage, and you pay only for the queries that you run.

Athena relies on the open source Presto distributed SQL query engine to enable both quick ad-hoc analysis and more complex requests, including window functions, large joins and aggregations.

Amazon Athena is able to process both unstructured and structured data types, data can be stored in the form of CSV, JSON or columnar data formats like Apache Parquet and Apache ORC. Athena can also be used to execute queries using ANSI SQL, which doesn’t require the user to aggregate or load data into Athena service.  Compressed data is also supported in Snappy, Zlib, LZO and GZIP formats.

The service provides great flexibility in how you run queries without the added complexity. Multiple concurrent queries can run all at the same time and most results are delivered within seconds. These actionable results from queries allow companies access to clean, reliable data to make better decisions and continue their research.

Athena also integrates with sophisticated BI tools like Tableau, Looker, Mode Analytics, AWS QuickSight, and others for advanced reports and visualizations.

Use Cases:

Big Data Platform for Data Warehouse and analytic database

Our Services:

Data Architecture, Data Modelling , Data Engineering and Development , Data Analysis

Share:

Share on facebook
Share on twitter
Share on linkedin
Share on whatsapp

More Posts

We Are Here For You :

Or fill in your details and we will contact you ASAP: