create schema product_reviews;

CREATE TABLE product_reviews.amazon_reviews
(
  marketplace varchar(2),
  customer_id bigint,
  review_id varchar(24),
  product_id varchar(24),
  product_parent bigint,
  product_title varchar(512),
  product_category varchar(32),
  star_rating int,
  helpful_votes int,
  total_votes int,
  vine char(1),
  verified_purchASe char(1),
  review_headline varchar(256),
  review_body varchar(max),
  review_date date

  )
DISTSTYLE EVEN;

copy  product_reviews.amazon_reviews from 's3://redshift-demos/data/datasharing/reviews_manifestfile.json'
iam_role '<your-cluster-iam-role>'
delimiter '\t'
ignoreheader 1
gzip
region 'us-east-1'
manifest;


