Introduction to Amazon Athena

Jowanza Joseph

@jowanza

www.jowanza.com

Agenda

  • About me ~ 1 minute
  • The mechanics behind Athena ~ 5 minutes
  • Cost structure of Athena ~ 1 minute
  • File format tradeoffs ~ 10 minutes
  • Demo ~ 20 minutes
    • File set up ~ 5 minutes
    • Query API ~ 5 minutes
    • Notebooks ~ 10 minutes

About Me

  • Software Engineer at One Click Retail
  • Spark / Flink: Scala / Java
  • Writing a book: The Apache Spark Field Book
  • gRPC 
  • Cycling / Golf
  • Proud Dad

An Example Big Data Stack

Compute & Storage

How Athena Works

Features

  • Serverless
  • Files stored on S3
  • Pay-per-query
  • SQL API
  • JDBC Connector
  • File format control

Cost Structure

$5 per Petabyte Scanned

File Formats

File Formats Matter

Compression

Basic Cheat Sheet

Demo

Introduction to Amazon Athena

By Jowanza Joseph

Introduction to Amazon Athena

Introduction to Amazon Athena given at the Utah AWS Meetup on April 26th 2017.

  • 2,239