Secure BigLake Data: Challenge Lab

[benvic]

Lab isn't marking as completed even after verifying that policy tags have been added to the specific columns. Any help would be appreciated

[atishay]

Same issue, did you get any solution.

[benvic]

Yeah. I placed the 'FROM' keyword on the second line. Hope it works.

[atishay]

From is already in the query.

[benvic]

Could you send a screenshot?

[atishay]

 Here is the screenshot attached.

[benvic]

Like I said, try putting the FROM 'PROJECT_ID.online_shop.user_online_sessions' on line 2 and see if it works

[atishay · Accepted solution]

I resolve it, there is bug in qwiklab check system-

query1- 

SELECT * EXCEPT(zip, latitude, ip_address, longitude) FROM `qwiklabs-gcp-04-00544c8b6140.online_shop.user_online_sessions`

query2- 

SELECT * EXCEPT(zip,latitude,ip_address,longitude) FROM `qwiklabs-gcp-04-00544c8b6140.online_shop.user_online_sessions`

Bug- Both query are same and are giving same output, but qwiklabs is considering query1 as solution because it has space between column name in except.

[benvic]

Nice.Did the same together with the suggestion I made, but couldn't figure out which of them worked for me.