Skip to content

Instantly share code, notes, and snippets.

@subuk
Created June 28, 2017 12:33
Show Gist options
  • Select an option

  • Save subuk/382ae96d7b9c98da1cbdb48c32aaeef5 to your computer and use it in GitHub Desktop.

Select an option

Save subuk/382ae96d7b9c98da1cbdb48c32aaeef5 to your computer and use it in GitHub Desktop.
Cloudfront log table sql
CREATE TABLE cf_imageproxy_20170611 (
logdate character varying(65535),
logtime character varying(65535),
edge character varying(40),
bytessent integer,
cip character varying(50),
method character varying(50),
host character varying(65535),
uri character varying(65535),
status character varying(20),
creferrer character varying(65535),
useragent character varying(65535),
cs_uri_query character varying(65535),
cookie character varying(65535),
x_edge_result_type character varying(65535),
x_edge_request_id character varying(65535),
x_host_header character varying(65535),
protocol character varying(10),
cs_bytes integer,
time_taken character varying(65535),
x_forwarded_for character varying(65535),
ssl_protocol character varying(65535),
ssl_cipher character varying(65535),
x_edge_response_type character varying(65535),
cs_protocol_version character varying(65535)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment