Can I integrate with Google BigQuery API to query Gmail logs from Panther?
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.