Query with Athena

Query with Athena

In this section we will perform data queries using the Amazon Athena service. Athena can connect to the AWS Glue Data catalog to read metadata information and directly query data located in an S3 bucket.

Content

  1. Install Athena
  2. Basic query
  3. Join 2 tables
  4. Create table as selected
  5. I view
  6. Partition in Athena
  7. Columnar vs Row based