Amazon Athena DDL for SNS Delivery Status Logs

sns_delivery_status_logs.hql

CREATE EXTERNAL TABLE IF NOT EXISTS sns_delivery_status_logs (
  status string,
  notification struct<
    timestamp:string,
    messageId:string>,
  delivery struct<
    statusCode:int,
    dwellTimeMs:int,
    token:string,
    attempts:int,
    providerResponse;string,
    destination:string>
)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
LOCATION 's3://your_log_bucket/prefix/';