Creating Permanent Tables and Access-Controlled Views in BigQuery Reviews

Sukanya R. · Reviewed over 4 years ago

Si J. · Reviewed over 4 years ago

test

Wilson Hooi Kuok L. · Reviewed over 4 years ago

useful hints like String_Agg function and Expiration titimestamp options

Muhammed Enes K. · Reviewed over 4 years ago

Jun Liang Y. · Reviewed over 4 years ago

Kelly C. · Reviewed over 4 years ago

Chang Boon H. · Reviewed over 4 years ago

Haziq Mudzakir . · Reviewed over 4 years ago

Sukanya R. · Reviewed over 4 years ago

Jose F. · Reviewed over 4 years ago

Hon Hoe Dominic W. · Reviewed over 4 years ago

Umesh P. · Reviewed over 4 years ago

Wendi K. · Reviewed over 4 years ago

Thank You

Ahmed E. · Reviewed over 4 years ago

in some task there are additional conditions, f.ex. for a date, and in the view, there are no conditions for the date. When I added the condition for a date,the view was no validated by the checked point

Małgorzata Ś. · Reviewed over 4 years ago

I could not understand why the table all_sessions_raw_(1) was mentioned in this lab. ------------------ Browse your ecommerce dataset panel to confirm the all_sessions_raw_(1) is present. Why is the full table name not showing? Answer: The table suffix 20170801 is automatically partitioned by day. If we created more tables for other days, the all_sessions_raw_(N) would increment by N distinct days of data. There is another lab that explores different ways of partitioning your data tables. ------------------------ The answer to "Query 2: Columns revisited" seems incorrect: Question: What is wrong with the previous query which lists products? Answer: Rule #2 the query statement names are ignored My understanding is: the correct answer is not in any of the four options. The error clearly tells that select * should not be used when the columns are specified: Error: The number of columns in the column definition list does not match the number of columns produced by the query at [5:1]

Ajay K. · Reviewed over 4 years ago

Tatiana V. · Reviewed over 4 years ago

Marcel S. · Reviewed over 4 years ago

Mayra Elizabeth G. · Reviewed over 4 years ago

Serhii K. · Reviewed over 4 years ago

Y G H. · Reviewed over 4 years ago

Nakul S. · Reviewed over 4 years ago

1h30 would be better

Thierry L. · Reviewed over 4 years ago

Surivi J. · Reviewed over 4 years ago

Samiksha N. · Reviewed over 4 years ago