Create tables using AWS Glue or the Athena console

Open the Athena console at https://console.aws.amazon.com/athena/.

In the query editor, next to Tables and views, choose Create, and then choose AWS Glue crawler.

Follow the steps on the Add crawler page of the AWS Glue console to add a crawler.

For more information, see Use a crawler to add a table.

Open the Athena console at https://console.aws.amazon.com/athena/.

In the query editor, next to Tables and views, choose Create, and then choose S3 bucket data.

In the Create Table From S3 bucket data form, enter the information to create your table, and then choose Create table. For more information about the fields in the form, see Use a form in the Athena console to add an AWS Glue table.

From the Database menu, choose the database for which you want to create a table. If you don't specify a database in your CREATE TABLE statement, the table is created in the database that is currently selected in the query editor.

In the query editor, enter a statement as shown in the following example and then choose Run.

CREATE EXTERNAL TABLE myopencsvtable (
   firstname string,
   lastname string,
   job string,
   country string
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
   'separatorChar' = ',',
   'quoteChar' = '"',
   'escapeChar' = '\\'
   )
STORED AS TEXTFILE
LOCATION 's3://amzn-s3-demo-bucket/mycsv/';