Can I integrate with Google BigQuery API to query Gmail logs from Panther?
Last updated: August 23, 2024
QUESTION
How can I integrate with Google BigQuery API to query Gmail logs from Panther?
ANSWER
Panther does not have a native integration to query Gmail logs, but there are two possible workarounds:
Export Big Query table data to Google Cloud Storage (GCS), and configure GCS as a Data Transport in Panther. Gmail generates one BigQuery table per day.
BigQuery supports scheduled queries and you could potentially leverage the EXPORT DATA statement to continuously query for new data on the partitioned table itself.