The example also specifies that the fields are tab separated (FIELDS TERMINATED BY ‘t’) and that each record in the file ends in a newline character (LINES TERMINATED BY ‘n). Finally, the LOCATION clause specifies the path in Amazon S3 where the actual data to be read is located.
https://docs.aws.amazon.com/athena/latest/ug/getting-started.html