Protect data with authorized views

[@GianluigiSartori-j6c]

Hi Alicia. If i created an Authorized view AW1 on base table BT1, what happens if i recreate the BT1 -> BT2 - keeping the same name and schema but with a new Created date? The AW is just a 'SELECT * from BTx' (BT1 or BT2 is the same name) We cannot access the data anymore. So is the AW1 to be recreated too? The question looks silly but we have diverging opinions. Thanks.

[@gabrielbiacchi6169]

Very useful

[@endritpasho5578]

BigQuery User role at the project level will give permissions to create datasets and tables. Can it be BigQuery Job User instead?

[@aliciawilliams5520]

BigQuery Job User works! Also, the analysts can run the job in another project (which may be preferred for billing reasons), so they essentially just need to have Job User role in a project, no specifically this one.

[@hakhandare]

Thank ,Now I am cleared with concepts.

[@saurabh1735]

This is just wowly explained

[@itplacementprep]

Hi, Since Authorized view is created on base table, will it always have updated data if the underlying table have any change in data ?

[@aliciawilliams5520]

The view in this video is a logical view, meaning that the query that defines the view is run each time the view is queried. The query results will always represent the current data.

[@Shruti-ss6cx]

The link is not helping it says 'Unable to load query. Requested entity was not found.'

[@aliciawilliams5520]

Thank you for your note- I've just updated the links, please let me know if they don't work for you now.

[@VivekSingh-tk7rp]

This is excellent demo. If you please share or redirect to terraform code for same steps

[@aliciawilliams5520]

That's a great idea Vivek! While I don't have a sample available, it looks possible via the Terraform documentation and via a web search I saw a few posts folks have created on how to do it.

[@princechawla4553]

very well explained. Thanks.

[@fernandop.5206]

Thanks Alicia :)

[@katehillier1027]

Censorship for companies for opaque unaccountable companies.

[@katehillier1027]

Add interesting things about shared subset of people. Hilarious!

[@katehillier1027]

Privacy not built in profits would suffer.

[@Tharudisa-c9w]

Kohomada me thayagaya labaganne Mama Ada jayaggrhanaya kara

[@keliu2313]

When I was following the link for Copy the “source data” query/Copy the “shared view” query, it all gave me "Unable to load query. Requested entity was not found.".

[@aliciawilliams5520]

Thank you for your comment! I just updated the links so please try them again and reply if they don't work for you.

[@diysumit]

these dashboards are really old

[@jamesleleji9470]

If a data is protected with authorized view, can it still be downloaded onto your computer? Thanks

[@aliciawilliams5520]

You are able to take the results of a query (including a query of an authorized view) and download according to this documentation: cloud.google.com/bigquery/docs/writing-results#downloading-saving-results-console.

[@jamesleleji9470]

@@aliciawilliams5520 What i want is to prevent users from downloading the data. I only want them to view it. How can i do this?

[@aliciawilliams5520]

@@jamesleleji9470 There is a specific permission needed to export a table (cloud.google.com/bigquery/docs/exporting-data#permissions_to_export_data_from_a_table) and you could test removing that to see if it has the right effect for your use case. Another option would be to share the data via Data Studio which you can set up to allow the viewer to filter and slice data according to the charts and visuals you create, while not giving them access to view the underlying data. More info here: support.google.com/datastudio/answer/10403868?hl=en

[@shatakshiagrawal3062]

@@aliciawilliams5520 Awesome! thanks!