Setting up Athena manually
We strongly recommend that you use the Amazon CloudFormation template to create your table instead of creating it yourself. The provided SQL query creates a table that covers only a single month of data, but the Amazon CloudFormation template creates a table that can include multiple months and that updates automatically. For more information on how to set up the Amazon CloudFormation template, see Setting up Athena using Amazon CloudFormation templates.
If you choose not to use the Amazon CloudFormation template to set up your Athena table, manually follow the steps below. You need to create a table before you can run SQL queries on your Amazon CUR data. You will need to do this step at least once a month and the table only includes data from the current Amazon CUR.
As part of the table creation process, Amazon transforms the Amazon CUR column names. For more information about the transformation process, see Column names.