Creating Permanent Tables and Access-Controlled Views in BigQuery Reviews

the test case with a view for top 10 large products does not work properly. I created the view, but it didn't work.

Konstantin K. · Reviewed 3 ימים ago

Enrico F. · Reviewed 3 ימים ago

Marko M. · Reviewed 3 ימים ago

Sadu T. · Reviewed 3 ימים ago

Sachin M. · Reviewed 4 ימים ago

Christian B. · Reviewed 4 ימים ago

Andrei S. · Reviewed 4 ימים ago

Diego Andrés A. · Reviewed 4 ימים ago

Radoslav H. · Reviewed 4 ימים ago

Lucas B. · Reviewed 4 ימים ago

PABLO G. · Reviewed 4 ימים ago

sree l. · Reviewed 4 ימים ago

ok

Jose V. · Reviewed 4 ימים ago

Marin B. · Reviewed 4 ימים ago

Govind K. · Reviewed 4 ימים ago

the possible solution provided in 'Extra Credit' seems incorrect (BigQuery silently ignore the unsupported option) for setting expiration date for view. The correct process is Create a logical view via DDL, then apply it after the view is created using an ALTER VIEW statement, like this. ALTER VIEW ecommerce.vw_large_transactions SET OPTIONS ( expiration_timestamp=TIMESTAMP_ADD(CURRENT_TIMESTAMP(), INTERVAL 90 DAY) );

Sam Z. · Reviewed 4 ימים ago

Saikat D. · Reviewed 4 ימים ago

Sandeep G. · Reviewed 5 ימים ago

Keshav R. · Reviewed 5 ימים ago

Thiện C. · Reviewed 5 ימים ago

Himanshu G. · Reviewed 5 ימים ago

İkbal A. · Reviewed 5 ימים ago

Mark M. · Reviewed 6 ימים ago

Adam Daniel B. · Reviewed 6 ימים ago

Harshit K. · Reviewed 6 ימים ago