Anyone you share the spreadsheet with will see the data contained in the sheet. Only those with edit access in Sheets and view access to the BigQuery table have the ability to refresh the dataset.
For key permissions for the BigQuery data connector see here. As always, use share permissions to control who can view, edit or share your data.
In the coming weeks, you’ll be able to use tools like Apps Script and the macro recorder to schedule automatic updates within Sheets to the connected BigQuery data. For example, you can automatically refresh sales data in your spreadsheet so the data is fresh and ready for analysis at the beginning of the day. To learn more about how to record or run macros in Sheets, check out this G Suite Pro Tip.
Instead of having to create drawings manually in a document, you can embed drawings from Drive in a document and refresh the content to keep it current. When you embed a drawing, the drawing is placed in the document, but linked to the original in Google Drawings. By using the “Update” button, you can update the drawing’s content with one click if changes are made to the source file. You can also choose to unlink drawings at a later date.
How to get started
Admins: No action needed.
End users: This feature can be accessed from the “Insert” menu in Docs. For further instructions, check out the Help Center.
In the Google Cloud Community, connect with Googlers and other Google Workspace admins like yourself. Participate in product discussions, check out the Community Articles, and learn tips and tricks that will make your work and life easier. Be the first to know what's happening with Google Workspace.
On the “What’s new in Google Workspace?” Help Center page, learn about new products and features launching in Google Workspace, including smaller changes that haven’t been announced on the Google Workspace Updates blog.