A DDL to convert Papertrail logs into an AWS Athena table. Raw

ddl-athena-papertrail-logs.sql

CREATE EXTERNAL TABLE IF NOT EXISTS cicero.papertrail (
  `id` bigint,
  `generated_at` string,
  `received_at` string,
  `source_id` bigint,
  `source_name` string,
  `source_ip` string,
  `facility_name` string,
  `severity_name` string,
  `program` string,
  `message` string 
) PARTITIONED BY (
  dt string 
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '	',
  'field.delim' = '	'
) LOCATION 's3://cicero-logs/papertrail/'
TBLPROPERTIES ('has_encrypted_data'='false');