Amazon Athena | Querying and Data Formats

Question 1

I already have large quantities of log data in Amazon S3. Can I use Amazon Athena to query it?

Querying and Data Formats

Amazon Athena | Analytics

Answer 1

Yes, Amazon Athena makes it easy to run standard SQL queries on your existing log data. Athena queries data directly from Amazon S3 so there’s no data movement or loading required. Simply define your schema using DDL statements and start querying your data right away.

Question 2

What kinds of queries does Amazon Athena support?

Querying and Data Formats

Amazon Athena | Analytics

Answer 2

Amazon Athena supports ANSI SQL queries. Amazon Athena uses Presto, an open source, in-memory, distributed SQL engine, and can handle complex analysis, including large joins, window functions, and arrays.

Question 3

Can I use Amazon QuickSight with Amazon Athena?

Querying and Data Formats

Amazon Athena | Analytics

Answer 3

Yes. Amazon Athena integrates with Amazon QuickSight, allowing you to easily visualize your data stored in Amazon S3.

Question 4

Does Athena support other BI Tools and SQL Clients?

Querying and Data Formats

Amazon Athena | Analytics

Answer 4

Yes. Amazon Athena comes with a JDBC driver you can use with other business intelligence tools and SQL clients. Learn more about using a JDBC driver with Athena.

Question 5

Does Athena support User Defined Functions (UDFs)?

Querying and Data Formats

Amazon Athena | Analytics

Answer 5

Currently, Athena does not support custom UDFs. If you need custom UDF support, please email us at athena-feedback@amazon.com so we can learn more about your requirements.

Question 6

How do I access the functions supported by Amazon Athena?

Querying and Data Formats

Amazon Athena | Analytics

Answer 6

Click here to learn more about functions supported by Amazon Athena.