Hello,
I’ve noticed that Workspace Biquery Gmail logs didn’t record any gmail.event_info.mail_event_type value from 2022-08-06 till 2023-03-15, always returned “null” value for more than 8 months.
Any idea?, is there someone with same issue?
A select to check it:
SELECT email, gmail.message_info.source.service as SrcService, gmail.message_info.source.selector as SrcSelector, gmail.message_info.destination[safe_offset(0)].service as DstService, gmail.message_info.destination[safe_offset(0)].selector as DstSelector, gmail.message_info.action_type as MsgInfo_action_type, # message_info.message_set ==> REPEATED gmail.message_info.message_set[safe_offset(0)].type as MsgSet_type, _PARTITIONTIME, TIMESTAMP_MICROS(gmail.event_info.timestamp_usec) AS Date, gmail.message_info.connection_info.client_ip as ClientIP, gmail.message_info.rfc2822_message_id AS MsgID, gmail.message_info.source.address AS From_Address, gmail.message_info. source.from_header_address AS from_header_address,gmail.message_info.destination[safe_offset(0)].address AS To_Address, gmail.message_info.flattened_destinations AS To_All_Addrs, gmail.message_info.subject, gmail.event_info.client_context.session_context.delegate_user_email AS delegate_user_email, gmail.event_info.mail_event_type AS mail_event_type, FROM bigquery-upc-logs.BigQuery_UPC_logs_dataset.activity #WHERE _PARTITIONTIME BETWEEN TIMESTAMP(‘2022-08-06’) AND TIMESTAMP(‘2023-03-15’) AND gmail.event_info.timestamp_usec is not null WHERE _PARTITIONTIME BETWEEN TIMESTAMP(‘2022-08-06’) AND TIMESTAMP(‘2023-03-15’) AND gmail.event_info.timestamp_usec is not null AND gmail.event_info.mail_event_type is not null ORDER BY gmail.event_info.timestamp_usec LIMIT 100 |
|---|