Yelp Reviews data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: REVIEW

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
reviews__avatar
Display name Avatar
Description Avatar
Field type dimension
Data type string.text.url
reviews__id
Display name ID
Description ID of the review
Field type dimension
Data type string.text.value
reviews__language
Display name Review language
Description Language of the review
Field type dimension
Data type string.geo.country.twolettercode
reviews__rating
Display name Rating
Description Rating of the review
Field type dimension
Data type int.number.value
reviews__reply
Display name Reply
Description The replied text
Field type dimension
Data type string.text.value
reviews__reply_datetime
Display name Reply time
Description Date and time when reply was written
Field type dimension
Data type string.text.value
reviews__review_date
Display name Created at date
Description Date when review was written
Field type dimension
Data type string.time.date
reviews__review_datetime
Display name Created at datetime
Description Date and time when review was written
Field type dimension
Data type string.time.datetime
reviews__reviewer
Display name Reviewer
Description Name of the reviewer
Field type dimension
Data type string.text.value
reviews__text
Display name Text
Description Text written for the review
Field type dimension
Data type string.text.value
reviews__url
Display name Link to review
Description A link to the review
Field type dimension
Data type string.text.url
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date