Run a CREATE TABLE statement similar to the below example. This statement creates an Athena table, sets case.insensitive to false, and maps column names to JSON keys that aren't identical to the column names. Before running this statement, note the following:
In the LOCATION field, replace s3://awsexamplebucket/AWSLogs/ with the name of your Amazon Simple Storage Service (Amazon S3) bucket.
Replace all mapping properties with your column names and JSON keys (for example, mapping.fileversion'='fileVersion').