AWS billing Athena schema

aws_billing.sql

CREATE EXTERNAL TABLE `billing`(
  `invoiceid` string, 
  `payeraccountid` string, 
  `linkedaccountid` string, 
  `recordtype` string, 
  `recordid` string, 
  `productname` string, 
  `rateid` string, 
  `subscriptionid` string, 
  `pricingplanid` string, 
  `usagetype` string, 
  `operation` string, 
  `availabilityzone` string, 
  `reservedinstance` string, 
  `itemdescription` string, 
  `usagestartdate` string, 
  `usageenddate` string, 
  `usagequantity` double, 
  `blendedrate` double, 
  `blendedcost` double, 
  `unblendedrate` double, 
  `unblendedcost` double, 
  `resourceid` string, 
  `user_name` string, 
  `user_project` string, 
  `user_role` string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
   'separatorChar' = ',',
   'quoteChar' = '\"',
   'escapeChar' = '\\'
)
STORED AS TEXTFILE
LOCATION 's3://TODO/'
TBLPROPERTIES ("skip.header.line.count"="1")