Criar um data warehouse com o BigQuery: laboratório com desafio avaliações

India P. · Revisado há over 2 years

Sai Bhuvandeep N. · Revisado há over 2 years

Shaifali G. · Revisado há over 2 years

Mario B. · Revisado há over 2 years

Boris M. · Revisado há over 2 years

Sandeep M. · Revisado há over 2 years

Sasikumar S. · Revisado há over 2 years

Sasikumar S. · Revisado há over 2 years

剛 深. · Revisado há over 2 years

Shadi B. · Revisado há over 2 years

Margarita S. · Revisado há over 2 years

Oscar D. · Revisado há over 2 years

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. · Revisado há over 2 years

剛 深. · Revisado há over 2 years

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. · Revisado há over 2 years

JAVIER V. · Revisado há over 2 years

Katherine S. · Revisado há over 2 years

Peter I. · Revisado há over 2 years

Enmanuel L. · Revisado há over 2 years

Nathan F. · Revisado há over 2 years

Dharmesh V. · Revisado há over 2 years

Dharmesh V. · Revisado há over 2 years

Cainã T. · Revisado há over 2 years

剛 深. · Revisado há over 2 years

Kamil K. · Revisado há over 2 years