Skip to content

Instantly share code, notes, and snippets.

@ankit-crossml

ankit-crossml/athena_create.sql

Last active April 14, 2020 08:52
Show Gist options
  • Save ankit-crossml/5bd39df9d2b026156196e9887a603d69 to your computer and use it in GitHub Desktop.
Save ankit-crossml/5bd39df9d2b026156196e9887a603d69 to your computer and use it in GitHub Desktop.
Download ZIP
Medium Blog - Athena S3 - create table gist
Raw
athena_create.sql
CREATE EXTERNAL TABLE IF NOT EXISTS athena_example (
request_timestamp string,
request_ip string,
request_port int,
backend_ip string,
backend_port int,
request_processing_time double,
protocol string,
user_agent string,
ssl_protocol string)
LOCATION 's3://athena-examples/elb/raw/';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment