Setting up the Reviews Table

Create the Amazon Reviews base table

Please skip and move over to the next lab, if you have already created the amazon_reviews_parquet table in one of the earlier labs

We will be working with Amazon Reviews data in this workshop. Let us start by creating an external table on top of the reviews dataset.

There are two ways to execute the lab. You can either use the saved queries that are readily available to you or, you can manually execute the queries.

Please click on the appropriate link below to continue.

Instructions to execute saved query

Instructions to execute manually

Once both queries are executed, you should be able to preview the amazon_reviews_parquet table
   select * from default.amazon_reviews_parquet limit 10;
We will use this table for the rest of this workshop.