Google Workspace Updates: Use Connected Sheets with VPC-SC protected data, improved Cloud Audit Logs for Connected Sheets events

Use Connected Sheets with VPC-SC protected data, improved Cloud Audit Logs for Connected Sheets events

2022년 5월 19일 목요일

What’s changing BigQuery datasets that are behind a perimeter created by VPC Service Controls can now be accessed using Connected Sheets.

We’ve also made improvements to the Connected Sheets logging in the Cloud Audit Logs. See the “Additional details” section below for more information.

Who’s impacted Admins and end users

Why you’d use it This change gives VPC Service Controls Admins and Editors the ability to allow members of your organization to access, collaborate on, and generate insights from VPC Service Controls protected data via Connected Sheets.

Additional details By default, Connected Sheets cannot access BigQuery data that is protected by VPC Service Controls; however, VPC Service Controls perimeters can now be configured to allow queries issued through Connected Sheets to succeed. This configuration can only be changed by VPC Service Controls Admins and Editors.

Improved Connected Sheets logging Whenever BigQuery data is accessed in Connected Sheets, entries are recorded for who accessed the data and when in Cloud Audit Logs.

Now, the Cloud Audit Logs additionally includes the ID of the spreadsheet that generates the BigQuery data access. Every spreadsheet has a unique ID containing letters, numbers, hyphens, or underscores, which can be found in the Google Sheets URL. Use this documentation to learn more about where to find this additional information in the Cloud Audit Logs.

Getting started

Policy Admins and Policy Editors: Visit the Help Center to learn more about configuring your VPC Service Controls perimeter to allow queries issued through Connected Sheets.
End users: When configured properly as described above, Sheets users can query VPC Service Controls-protected BigQuery data via Connected Sheets just like they ordinarily would query non-VPC Service Controls-protected data. Visit the Help Center to learn more about using Connected Sheets with BigQuery data.

Rollout pace

Availability

Available to all Google Workspace customers
Available to users with personal Google Accounts
Not available to legacy G Suite Basic and Business customers

Resources

Useful Links

Join the official community for Google Workspace administrators

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.

______________

Learn about more Google Workspace launches

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.

______________

Updates

Use Connected Sheets with VPC-SC protected data, improved Cloud Audit Logs for Connected Sheets events

Filter by product

Filter by date

Subscribe by feed

Subscribe by email

Localized Google Workspace Updates

Useful Links

Join the official community for Google Workspace administrators

Learn about more Google Workspace launches