Create Athena Table for CSVs

create-athena-table-for-csvs.sql

CREATE EXTERNAL TABLE IF NOT EXISTS athenadatabaseforcsvs.athenatableforcsvs (
  aws_account_id string,
  name string,
  email string,
  status string,
  category string,
  description string,
  refreshed string,
  processed string,
  flagged string,
  percent_flagged string,
  ta_proposed_actions string
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
   'separatorChar' = ',',
   'quoteChar' = '\"',
   'escapeChar' = '\\'
   )
STORED AS TEXTFILE
LOCATION 's3://bucket-with-csvs/';