Athena Create View
A view in Amazon Athena is a logical, not a physical table. The query that defines a view runs each time the view is referenced in a query.
You can create a view from a SELECT query and then reference this view in future queries. For more information, see CREATE VIEW
Click on Saved Queries under Athena Console and the open Athena_create_view_top_rated
Run the first query by highlighting which will create the view called topratedproducts
. Once the view is created it will appear under Athena Views.
Select the second query and see the top 10 products by rating.