Build a Data Warehouse with BigQuery: Challenge Lab Reviews

India P. · Reviewed מעל 2 שנים ago

Sai Bhuvandeep N. · Reviewed מעל 2 שנים ago

Shaifali G. · Reviewed מעל 2 שנים ago

Mario B. · Reviewed מעל 2 שנים ago

Boris M. · Reviewed מעל 2 שנים ago

Sandeep M. · Reviewed מעל 2 שנים ago

Sasikumar S. · Reviewed מעל 2 שנים ago

Sasikumar S. · Reviewed מעל 2 שנים ago

剛 深. · Reviewed מעל 2 שנים ago

Shadi B. · Reviewed מעל 2 שנים ago

Margarita S. · Reviewed מעל 2 שנים ago

Oscar D. · Reviewed מעל 2 שנים ago

Lab is very particular about how you specify the table expiration date. You have to specify the expiration_days instead of expiration_date as date_add(current_date, interval 1080 day). I would see either way as sufficient in the real world. If the lab requires use of a specific option then that should be called out.

Kenneth W. · Reviewed מעל 2 שנים ago

剛 深. · Reviewed מעל 2 שנים ago

Lab is broken. I created the initial table with partition on date and expiration date 1080 days after the creation time twice and it never accepted it. I think it is because the lab shows the creation time of the table in UTC-6 but shows the expiration as UTC-5.

Kenneth W. · Reviewed מעל 2 שנים ago

JAVIER V. · Reviewed מעל 2 שנים ago

Katherine S. · Reviewed מעל 2 שנים ago

Peter I. · Reviewed מעל 2 שנים ago

Enmanuel L. · Reviewed מעל 2 שנים ago

Nathan F. · Reviewed מעל 2 שנים ago

Dharmesh V. · Reviewed מעל 2 שנים ago

Dharmesh V. · Reviewed מעל 2 שנים ago

Cainã T. · Reviewed מעל 2 שנים ago

剛 深. · Reviewed מעל 2 שנים ago

Kamil K. · Reviewed מעל 2 שנים ago