athena.sql

CREATE EXTERNAL TABLE IF NOT EXISTS
    cloudfront_logs.staging_partitioned (
         date DATE,
         time STRING,
         edge_location STRING,
         response_bytes BIGINT,
         ip STRING,
         method STRING,
         host STRING,
         uri STRING,
         status INT,
         referrer STRING,
         user_agent STRING,
         query_string STRING,
         cookies STRING,
         edge_result_type STRING,
         edge_request_id STRING,
         host_header STRING,
         protocol STRING,
         request_bytes BIGINT,
         time_taken FLOAT,
         x_forwarded_for STRING,
         ssl_protocol STRING,
         ssl_cipher STRING,
         response_result_type STRING,
         http_version STRING,
         fle_status STRING,
         fle_encrypted_fields INT
)
PARTITIONED BY (
         year string,
         month string,
         day string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LOCATION 's3://staging-bucket-name/partitioned/'
TBLPROPERTIES ( 'skip.header.line.count'='2');