Create view

Create views in Athena

  1. Execute the query below.
create view join_view
as
select listings.name, count(reviews.review_id) as total_reviews
from
listings
inner join
reviews
on listings.listing_id=reviews.listing_id
group by listings.name;

This query will create a view called join_view that contains the total number of reviews made on each Airbnb location in the listings table. Creating views will not create new data. The view definition query will be executed every time the view is used in another query.

DataLake