Supported editions for this feature: Frontline Standard; Enterprise Standard and Enterprise Plus; Education Standard and Education Plus; Enterprise Essentials Plus. Compare your edition
Before you start using Gmail logs with BigQuery, complete the steps in this article.
To streamline your BigQuery tasks and let you manage all your BigQuery data in one place, we’re merging Gmail logs in BigQuery with Workspace logs and reports in BigQuery, starting in February 2023. You’ll manage BigQuery logs and reports for all your Workspace services in the same place in your Google Admin console. We recommend that you migrate your Gmail BigQuery views, queries, and scripts to Workspace logs and reports in BigQuery as soon as possible. For detailed steps, go to Migrate Gmail logs in BigQuery to Workspace logs in BigQuery.
Set up your project
- Find an active BigQuery project to use, or create a BigQuery project.
Note: If you don't have a BigQuery account, set up a free trial to try BigQuery.
- Go to the IAM & Admin page for your project.
- Add a project editor for your project. The project editor sets up the BigQuery project in the Google Admin console.
- At the top of the page, click ADD.
- In New members, enter the project editor's user ID.
- In Select a Role, select Project, then Editor.
- Optionally, click ADD ANOTHER ROLE to add the same person as the project owner: Select Project, then Owner.
- Click Save.
VPC Service Controls
If you use VPC service controls with your Google Cloud project, they must be turned off in the BigQuery project so Gmail can export data to BigQuery. Off is the default setting.
Domain Restricted Sharing
If you restrict identities by domain in Google Cloud, you might need to change some settings to support Gmail logs in BigQuery. Learn more in Restricting Identities by Domain.
