0

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

Vibhor Jain
  • 1,396
  • 1
  • 11
  • 32

1 Answers1

3

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

Graham Polley
  • 14,393
  • 4
  • 44
  • 80
  • Thanks for clarification! In that case I was expecting `protoPayload.serviceData.jobCompletedEvent.job.jobStatistics` (or `serviceData.jobInsertResponse.resource.jobStatistics` to populate with cacheHit True or False field... perhaps Cache configurations are not exposed in Audit Logs (they're only available in actual API req / res?!) – Vibhor Jain Jun 30 '18 at 22:29
  • Good point. Not sure why that's not returned. Maybe one of the Googlers can clarify. – Graham Polley Jul 01 '18 at 07:58