How to use row level permissions in BigQuery?

Question

Google announced this feature today, but I don’t see any documents for it. How can I provide row level permissions for a user?

For example, let's say I have a table private.all_customerswith a schema {customer:string, id:integer, is_secret:boolean}.

I like to give our sellers access to the fields customerand id, but not is_secret, and moreover, I would like to give them access only to those lines where is_secret = false. How can i do this?

Answer 1

, . , , , .

, , , . :

SELECT customer, id FROM private.all_customers where is_secret = false

public.public_customers public.

, , . , . , , . , , .

- ACL private. , . , private , , .

ACL - - BigQuery. private - " ", , ACL. " " . , " ". , , - project:dataset.view . my-project:public.public_customers. "", , " " .

ACL, , "" , public.public_customers.

, , . : BigQuery?