Skip to content

Instantly share code, notes, and snippets.

@jamiefrench
jamiefrench / athena-elb-partitioned-logs.txt
Last active Jul 10, 2019
AWS Athena Classic ELB - Partitioned by Year, Month, Day
View athena-elb-partitioned-logs.txt
CREATE EXTERNAL TABLE IF NOT EXISTS {{DATABASE_NAME.TABLE_NAME}} (
timestamp string,
elb_name string,
request_ip string,
request_port int,
backend_ip string,
backend_port int,
request_processing_time double,
backend_processing_time double,
View keybase.md

Keybase proof

I hereby claim:

  • I am jamiefrench on github.
  • I am jamiefrench (https://keybase.io/jamiefrench) on keybase.
  • I have a public key ASDxsFdDUKoMkUgQSrxZp1-5WUHgD8DeYFbH-B-ta9J5-wo

To claim this, I am signing this object: