Issue related to Secure big-lake Data: Challenge Lab

[amitpal16181]

I tried a lot to complete this challenge but it seems I'm unable to finish task 2. I don't understand well the requirements of the task, I think and need help in that.

Task 2. Apply and verify policy tags on columns containing sensitive data

1. Use the pre-created taxonomy named taxonomy name to apply column-level policy tags on the table.

• Apply the policy tag named sensitive-data-policy to the following columns in the user_online_sessions table:

  • zip
  • latitude
  • ip-address
  • longitude
2. Verify the column-level security by running a query that omits the protected columns.

The first part went well and I used the cloud documentation to learn and apply column-level policy tags. The issue came with the part 2 when I tried to run the query. I took help from different sources and tried all the queries that i can but the evaluator seems unhappy.

The query that I ran was:

SELECT column-name FROM `qwiklabs-gcp-04-5ce485ad00f1.online_shop.INFORMATION_SCHEMA.COLUMNS` WHERE table-name = 'user-online-sessions' AND column-name NOT IN ('zip', 'latitude', 'ip-address', 'longitude');

Can anyone help me know where am I doing wrong?

[janusz_szpilews · Accepted solution]

You must use a query of style "SELECT * EXCEPT()" See the lab "BigLake: Qwik Start" for further hints

[1_1]

Yeah I did tried and it works.