Google Workspace Updates: BigQuery

Workspace audit log exports in BigQuery now enriched with Drive label metadata

Wednesday, March 27, 2024

What’s changingGoogle Workspace audit logsGoogle Drive audit events
Today, we’re excited to announce that for admins who analyze these logs in BigQuery, these events are now enriched with Drive labels metadata. Admins leverage Drive labels to apply descriptive metadata, such as file sensitivity, to Drive items. With the enrichment of label metadata on log events, admins can now focus their analysis on activity occurring on their most important files by filtering on label conditions.

Getting started

Admins: Visit the Help Center to learn how to set up service log exports to BigQuery.
End users: There is no end user setting for this feature.

Rollout pace

This feature is available now.

Availability

Available to Enterprise Essentials Plus, Enterprise Standard and Enterprise Plus, Education Standard and Education Plus

Resources

Google Workspace Updates Weekly Recap - February 2, 2024

Friday, February 2, 2024

3 New updatesUnless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.
New ways to work with filters in Connected Sheets for Looker and Connected Sheets for BigQuery

With Looker: Connected Sheets for Looker users will now be able to see whether Looker-defined filters, always_filters and conditionally_filters, are applied in their Google Sheets. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about always_filter and conditionally_filter in Looker.
With BigQuery: Connected Sheets for BigQuery users can now right-click any value in the Connected Sheets preview and filter rows in the preview on that specific value. As a result, a new query will be sent to BigQuery to re-fetch the preview. This new option provides an additional way to easily explore data in the Connected Sheets preview for BigQuery. | This is now available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about sorting & filtering BigQuery data in Google Sheets.

Latest improvement for page setup in Google Docs We’re introducing a new menu item within the Format option that enables you to easily switch between pageless and pages mode in Google Docs. | Rollout to Rapid Release domains is complete; launch to Scheduled Release domains planned for February 5, 2024. | Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about changing a document’s page setup.

Developers can now choose which calendar events to be notified about Developers using the Calendar API can now subscribe to specific changes in users’ calendars — this includes event types such as working ___location, out-of-office, or focus time. This update reduces the amount of notifications down to those that are most relevant to the developer. | Use our Developer Documentation for more information about subscribing to alerts for specific calendar event changes. | Rolling out now to Rapid Release domains and Scheduled Release domains. | The Calendar API is available to all Google Workspace customers, however Calendar features may vary across Google Workspace editions.

Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.

For Google Meet Hardware, ‘Auto-Update Expiration (AUE)’ will now be referred to as 'end of Meet support'

We’re making changes to the terminology that refers to when a Meet hardware device is no longer supported. | This update impacts all Google Workspace customers with Meet hardware devices. | Learn more about 'end of Meet support'.

Local data storage exports your organization's Workspace data into the geographic ___location of your choice, launching in beta

We’re introducing Google Workspace’s new feature, local data storage. This feature allows admins to export their organization’s Workspace data into the geographic ___location or locations of their choice. | Available to Google Workspace Enterprise Plus customers with Assured Controls add-on only. | Learn more about the local data storage exports beta.

Improving the Google Calendar appointment scheduling experience with new features

We’re improving upon the current appointment scheduling experience with four new features. | Co-hosts, secondary calendars and delegate access features are available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, and Nonprofits only. Check Calendars for availability feature is available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, Nonprofits, Google Workspace Individual subscribers, and users with personal Google accounts only. | Learn more about the appointment scheduling features.

Shareable class templates and classwork in Google Classroom are now generally available

Last year, we announced a Google Classroom beta that simplifies lesson planning with shareable class templates and classwork. We’re excited to announce that this is now globally available for Google Workspace for Education Plus customers in English, Spanish, Portuguese and Japanese. | Available to Education Plus only. | Learn more about shareable class materials.

Pin chat messages in Google Meet

You can now pin messages to the top of the meeting chat. Pinned messages will appear for all users, even if they join the meeting after the message was initially sent. | Learn more about messaging pinning.

Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.

Rapid Release Domains:

Improving the Google Calendar appointment scheduling experience with new features

Scheduled Release Domains:

Adding timezone support for existing smart chips in Google Docs
Combining multiple video effects (Web & Mobile availability)
Studio lighting (Web availability)

Rapid and Scheduled Release Domains:

For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Google Workspace Updates Weekly Recap - January 12, 2024

Friday, January 12, 2024

4 New updatesUnless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.
Version history limits for Apps Script projects For all new scripts, you’ll be able to create and save up to 200 versions of your script. If needed, you can permanently delete a script version from the project history page. | This is available now to all Google Workspace customers. | Learn more using our developer documentation on working with Apps Script versions.

Share a link to a specific time in a Google Drive video We’re adding new functionality to the Drive sharing button that lets you share timestamped links to specific parts of a video. On web, simply navigate to drive.google.com > find and open a video file > play the video (you can pause the playback before performing the following steps) > select the dropdown on the “Share” button in the top-right corner > select “Copy link to this time” > send the link. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to all Google Workspace customers and users with personal Google Accounts. | Learn more about copying a specific time in the video.

Share a link to a specific time in a Google Drive video

Introducing dropdown options on the sharing button in Google Docs, Sheets, Slides and DrawingsWe’re adding a new feature that ensures a seamless sharing experience across Workspace. In Google Docs, Sheets, Slides and Drawings, you will now see a dropdown on the Share button that surfaces quick actions, such as pending access requests and the “Copy link” option. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to all Google Workspace customers and users with personal Google Accounts.

Using functions in Connected Sheets for BigQuery Today, Connected Sheets for BigQuery supports 23 Sheets functions, such as AVERAGE and XLOOKUP. However, all of these functions behave somewhat differently than their native counterparts. Thus, to help Connected Sheets users write better functions, we now display context-aware Help Center content in Sheets. The ‘formula help’ shows descriptions for Connected Sheets functions when writing a formula that would query BigQuery, and otherwise shows descriptions of native Sheets functions. | This is available now to all Google Workspace customers and users with personal Google Accounts. | Learn more about the XLOOKUP function.

Previous announcementsThe announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.

Updates to metrics in Google Drive Apps Reports and Reports API We’re making some updates to the Google Drive metrics in the Admin Console Apps reports and the Reports API. As a result of these improvements, admins who analyze metrics will have more reporting clarity and can better understand activity trends within their ___domain. | Learn more about metrics in Drive Apps Reports and Reports API.

Easily share Google Drive files to Google Calendar meeting attendees

We’re introducing the option to share any file with all meeting participants on a Google Calendar invite via the sharing dialog within a file. | Learn more about sharing Drive files to Calendar.

Google Meet is now available on Logitech Android appliances

Google Meet is now supported on Logitech’s Rally Bar and Rally Bar Mini Android-based appliances for collaboration rooms and spaces of just about any size. After initial setup, admins can easily enroll, manage, and monitor these devices using the Google admin console. Google Meet on Logitech Android-based devices is supported on CollabOS v1.11 as a video conferencing provider | Learn more about Meet on Logitech Android appliances.

Google Meet hardware devices from Poly now support interoperability with Cisco Webex and Zoom

We’re expanding the existing interoperability between Google Meet, Cisco Webex, and Zoom to include Android-based Meet hardware devices from Poly. Specifically, these devices include: Poly Studio X30, X50, X52, and X70. | Learn more about support interoperability with Cisco Webex and Zoom.

Extending Trusted Types to Gmail

We’re excited to announce the expansion of Trusted Types to Gmail. This will provide a defense against DOM XSS and further enhances our advanced data protection controls to keep users and data safe across more of the apps they use everyday. | Learn more about Trusted Types.

Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.

Rapid Release Domains:

Scheduled Release Domains:

Rapid and Scheduled Release Domains:

For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Improving consistency of Gmail data across the Security Investigation Tool and BigQuery

Friday, May 26, 2023

What’s changing In August 2022, we announced the movement of the existing Gmail logs in BigQuery to Google Workspace logs and reports in BigQuery, creating a single space to access all of your Google Workspace audit events.

To further improve this experience, you’ll see all Gmail log events from the Security Investigation Tool (SIT) in your Google Workspace logs and reports in BigQuery. This includes device types and post-delivery actions (for example open, delete, clicked links, and attachment downloads). This change will give admins a more complete picture of Gmail activity happening in their ___domain, and bring consistency across reporting tools.

Use the table below to familiarize yourself with the newly added columns — complete details can be found in our Help Center.

List of newly added columns	Description
event_info.mail_event_type	The event type corresponds to the Event attribute in Gmail log events in Security Investigation Tool.
event_info.client_context.client_type	The type of client or device where the action occurred, including: WEB, IOS, ANDROID, IMAP, POP3, and API.
event_info.client_context.session_context.delegate_user_email	Email address of the delegated user who performed the action on the account owner's behalf.
message_info.attachment.file_name	File attachment name.
message_info.post_delivery_info	Information about the post-delivery event.
message_info.post_delivery_info.action_type	Post-delivery action type.
message_info.post_delivery_info.interaction	Information about the user's interaction with message links, Drive items, or attachments.
message_info.post_delivery_info.interaction.link_url	The URL associated with the interaction, which is set only for link click interactions.
message_info.post_delivery_info.interaction.drive_id	The unique ID of the Google Drive item associated with the interaction. This ID is used to access the item in Drive.
message_info.post_delivery_info.interaction.attachment	The target attachments of the interaction, which are set only for attachment interactions.
message_info.post_delivery_info.interaction.attachment.file_extension_type	File extension (not MIME part type), not including the period.
message_info.post_delivery_info.interaction.attachment.malware_family	Malware type, if malware is detected during message handling.
message_info.post_delivery_info.interaction.attachment.file_name	Attachment file name.
message_info.post_delivery_info.interaction.attachment.sha256	SHA256 hash of the attachment.

Getting started

Admins:

End users: There is no end user impact.

Rollout pace

Rapid Release and Scheduled Release domains: Available now

Availability

Available to Google Workspace Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Plus, Education Standard
Not available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Frontline, and Nonprofits, as well as legacy G Suite Basic and Business customers

Resources

Google Workspace Admin Help: Google Workspace logs and reports in BigQuery

Unified experience for Gmail logs in BigQuery, configure your existing Gmail logs to route to Workspace logs

Wednesday, August 10, 2022

What’s changing In the coming months, we will move the ___location of the existing Gmail logs in BigQuery to Google Workspace logs and reports in BigQuery. This change will only impact existing Google Workspace customers, who have BigQuery Export enabled. New customers will be guided through setting up a Workspace BigQuery project for Gmail logs.

While this change is happening, for a brief period of time, Gmail data will be exported to both the Gmail logs and the Workspace logs — existing Google Workspace customers who are impacted will receive an email notification with more information in the coming weeks.

Gmail logs in BigQuery

Migrating to Unified Workspace logs in BigQuery

Who’s impacted Admins

Why it’s important This change will create a single space to access all of your Google Workspace audit events and eliminate the need to switch between various sources of truth.

Once this merger is completed, you will not be able to use Gmail logs in BigQuery in the Admin console. Visit the Help Center for more information, including detailed step-by-step instructions on handling this change.

Additional detailsTemporary dual export period and BigQuery storage requirements Once Gmail logs are set to be exported to Workspace Logs, this data will temporarily exported to two destinations:

Your previous, Gmail-only BigQuery project
Your new or existing Workspace BigQuery project, which stores data for all Google Workspace applications

This will also impact your BigQuery quotas limits and how often they have to refresh, as well as the cost associated with exporting logs to BigQuery. To avoid impact on your quotas and duplicative data, we strongly recommend turning off Gmail log exports to your Gmail-only BigQuery projects.

Getting started

Admins: Visit the Help Center to learn more about Google Workspace logs and reports in BigQuery and moving your views, queries, and scripts from Gmail logs in BigQuery to Workspace logs in BigQuery.
End users: There is no end user impact.

Rollout pace

Rapid and Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on August 10, 2022

Availability

Available to Google Workspace Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Plus, Education Standard
Not available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Frontline, and Nonprofits, as well as legacy G Suite Basic and Business customers

Resources

Google Workspace Admin Help: Migrate Gmail logs in BigQuery to Workspace logs in BigQuery
Google Workspace Admin Help: Google Workspace logs and reports in BigQuery

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

Workspace audit log exports in BigQuery now enriched with Drive label metadata

Google Workspace Updates Weekly Recap - February 2, 2024

Google Workspace Updates Weekly Recap - January 12, 2024

Improving consistency of Gmail data across the Security Investigation Tool and BigQuery

Unified experience for Gmail logs in BigQuery, configure your existing Gmail logs to route to Workspace logs

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