O'Reilly logo

Effective Amazon Machine Learning by Alexis Perrier

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the wizard

There are two ways to create databases and tables in Athena, via the wizard or by running queries. The wizard is accessible by clicking on the Add table link in the Query Editor page:

In four steps, the wizard allows us to create the database, the table, and load the data. Creating the columns in step 3 involves manually typing the name of each column and specifying each column type. With 14 columns in the dataset, this manual approach is time-consuming. We will, therefore, not use the wizard and switch to creating the database and table directly in SQL:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required