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.
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.
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.
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.
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 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
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.".
![30 ชั่วโมงคนเดียว บนรถไฟชั้น 3 โซเวียต [Around The World Ep. 2]](http://i.ytimg.com/vi/MlE9boAVqDA/mqdefault.jpg)
![ไลฟ์สุ่ม iPhone 295 บาท... โกงมั้ย?[ โกงมั้ยครับ ep.97 ] | DOM](http://i.ytimg.com/vi/gdstHEE4UUE/mqdefault.jpg)
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.
BigQuery User role at the project level will give permissions to create datasets and tables. Can it be BigQuery Job User instead?
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.
Hi, Since Authorized view is created on base table, will it always have updated data if the underlying table have any change in data ?
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.
Very useful
This is just wowly explained
The link is not helping it says 'Unable to load query. Requested entity was not found.'
Thank you for your note- I've just updated the links, please let me know if they don't work for you now.
This is excellent demo. If you please share or redirect to terraform code for same steps
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.
Kohomada me thayagaya labaganne Mama Ada jayaggrhanaya kara
very well explained. Thanks.
Thank ,Now I am cleared with concepts.
If a data is protected with authorized view, can it still be downloaded onto your computer? Thanks
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.
@@aliciawilliams5520 What i want is to prevent users from downloading the data. I only want them to view it. How can i do this?
@@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
@@aliciawilliams5520 Awesome! thanks!
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.".
Thank you for your comment! I just updated the links so please try them again and reply if they don't work for you.
Thanks Alicia :)
Add interesting things about shared subset of people. Hilarious!
these dashboards are really old
Privacy not built in profits would suffer.
Censorship for companies for opaque unaccountable companies.