Prepare to use Gmail logs in BigQuery

Supported editions for this feature: Frontline Standard and Frontline Plus; 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.

Set up your project

1. 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.

2. Go to the IAM & Admin page for your project.

3. 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.