Registering S3 datasets in your metastore

Before you can query your data with Athena, the data must be registered in a data catalog. This section will review the different ways an S3 dataset can be registered in your metastore.

Using Athena CREATE TABLE statements

Athena's console allows you to create databases and tables in your metastore through two methods. The most often used method is generating and executing DDL statements. We have already seen a few examples of CREATE TABLE SQL statements to create tables. If you need a refresher, refer to the Tables section earlier in this chapter. Alternatively, you can click on the CREATE TABLE template within the Athena console, as shown in the following screenshot:

Figure 4.8 – Using a SQL template in the Athena console for CREATE TABLE

Using Athena's Create Table wizard

This method uses the Create Table wizard from the Athena console. It takes the necessary information, generates a CREATE...