1. Expel Support Center
  2. Expel Phishing
  3. Phishing setup

Enabling Gmail Logs in BigQuery

Sharon Burton
  • Updated

  1. Navigate to the Gmail setup console in Google Workspace admin: https://admin.google.com/ac/apps/gmail/setup

    mceclip0.png

  2. Hover over Email Logs in BigQuery and click the pencil icon. In the section that appears, select the Enable checkbox and type a Description. Select the same project that the service account belongs to from the previous steps.

  3. Type gmail_logs_dataset as the name for the new BigQuery dataset and click SAVE.

    mceclip1.png

  4. From the IAM console in the project where the service account was created, click the pencil icon and add the role BigQuery Job User to the service account.

    mceclip8.png

  5. Search for and add BigQuery Job User and click SAVE.

    mceclip9.png

  6. Navigate to BigQuery in the Google Cloud console: https://console.cloud.google.com/bigquery and find the gmail_logs_dataset. Open the menu on the right and click Open.

    mceclip2.png

  7. Default retention is set to 60 days, but we recommend changing that to 30 days. From the dataset details, click EDIT DETAILS.

    mceclip3.png

  8. Type the length of time to retain the log tables and click SAVE.

    mceclip13.png

  9. Click SHARING and select Permissions.

    mceclip4.png

  10. Add the service account under New principals and select the role BigQuery Data Viewer. Click SAVE to close the panel.

    mceclip15.png

  • Was this article helpful?

  • 0 out of 0 found this helpful

Related articles