-- -- This Athena statement creates a table entry in the Glue catalogue -- The data format is a TAB-seperated text file without header row -- CREATE EXTERNAL TABLE "${Database}"."loisville_ky_neighborhoods"( `objectid` int, `nh_code` int, `nh_name` string, `shapearea` double, `shapelen` double, `bb_west` double, `bb_south` double, `bb_east` double, `bb_north` double, `shape` string, `cog_longitude` double, `cog_latitude` double) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION 's3://${S3BucketExternalCode}/loisville_ky_neighborhoods/' TBLPROPERTIES ( 'has_encrypted_data'='false' )