Create a table in Athena from a csv file with header stored in S3.

amazon_athena_create_table.ddl

CREATE EXTERNAL TABLE IF NOT EXISTS default.table
(
  `id` int,
  `name` string,
  `timestamp` string,
  `is_debug` boolean
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
  'escapeChar'='\\', 
  'quoteChar'='\"', 
  'serialization.format' = ',',
  'field.delim' = ','
)
LOCATION 's3://your-bucket-name-xxxxx/your/folder'
TBLPROPERTIES (
  'skip.header.line.count'='1'
);