Search code examples
google-bigquerygoogle-cloud-stackdriver

BQ AuditLogs in StackDriver ::Missing fields in jobCompletedEvent.job.jobStatistics

Looking at BigQuery Audit logs in Stackdriver (using PY Client Libraries).. I'm a bit puzzeled why few fields billingTier, totalProcessedBytes, totalTablesProcessed etc. are missing from protoPayload.serviceData.jobCompletedEvent.job.jobStatistics

It happens with quite few of the Log Entries not just this one..

Thanks for clarification!

enter image description here

Solution

  • These are queries/jobs that have hit the cache. If you turn caching off and test, then you will see all the statistics that you listed.

    For example:

    enter image description here