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
Data Engineer Data Engineer’s role, responsibilities, skills , and what is the background they come from? More and
Data Warehouse is a data platform where organisations store all their information from external or internal sources .
MySQL 8 Galera Cluster High Availability In MySQL 8 Galera Cluster Installation we described how to set up
MySQL Galera Cluster Introduction MySQL Galera cluster is the common solution for MySQL high availability and bring
