dCKe7UnW

1CREATE EXTERNAL TABLE IF NOT EXISTS aws_billing_report.aws_detailed_billing (
2  `invoiceid` string,
3  `payeraccountid` string,
4  `linkedaccountid` string,
5  `recordtype` string,
6  `productname` string,
7  `rateid` string,
8  `subscriptionid` string,
9  `pricingplanid` string,
10  `usagetype` string,
11  `operation` string,
12  `availabilityzone` string,
13  `reservedinstance` string,
14  `itemdescription` string,
15  `usagestartdate` string,
16  `usageenddate` string,
17  `usagequantity` string,
18  `blendedrate` string,
19  `blendedcost` string,
20  `unblendedrate` string,
21  `unblendedcost` string 
22)
23ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
24WITH SERDEPROPERTIES (
25  'separatorChar' = ',',
26  'quoteChar' = '\"',
27  'escapeChar' = '\\'
28) LOCATION 's3://s3-bucket/'
29TBLPROPERTIES (
30  'has_encrypted_data'='false',
31  'skip.header.line.count'='1');