Logo Logo
Sign in
  • Home

  • Submit a request


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

Enabling Gmail Logs in BigQuery

Sharon Burton
  • Updated September 28, 2022 19:09

  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

  • Expel integrations guide
  • Gmail Report Phishing button set up
  • Google Cloud Platform setup for Workbench
  • Microsoft Office 365 Message Trace set up
  • Microsoft Defender for Cloud Apps setup for Workbench

Promoted articles

  • Add users to Workbench setup for Workbench
  • How to submit a support ticket in Workbench
  • Getting connected to Expel Workbench
  • Expel integrations guide
  • How to provision Expel Assembler
  • About Expel alerts, investigations, and incidents

Comments

0 comments

Article is closed for comments.

×
Copyright © 2021-2023 All Rights Reserved.