Configuring and Using VPC Flow Logs in Cloud Logging Reviews

Javier A. · Reviewed about 7 years ago

The BigQuery table does not contain the fields jsonPayLoad. The generic table name is changed for the dataset from compute to cloudaudit #standardSQL SELECT >>>>>>>jsonPayload.dest_instance, resource FROM `flowlogs_dataset.[>>>>compute<<<<]_googleapis_com_vpc_flows_*` WHERE >>>>>jsonPayload.connection.dest_port = 22 LIMIT 1000

Mohit G. · Reviewed about 7 years ago

Dirk W. · Reviewed about 7 years ago

Michael M. · Reviewed about 7 years ago

robinwakefield r. · Reviewed about 7 years ago

5 stars, initial error resolved

michael o. · Reviewed about 7 years ago

Rob B. · Reviewed about 7 years ago

Amadou Diama N. · Reviewed about 7 years ago

Errors at the BigQuery Query section

David G. · Reviewed about 7 years ago

antonio g. · Reviewed about 7 years ago

ok

Andrea P. · Reviewed about 7 years ago

Edwin C. · Reviewed about 7 years ago

Gaurav T. · Reviewed about 7 years ago

Balaji K. · Reviewed about 7 years ago

Kenneth S. · Reviewed about 7 years ago

Emil D. · Reviewed about 7 years ago

Fernando F. · Reviewed about 7 years ago

Antoni T. · Reviewed about 7 years ago

Motasem H. · Reviewed about 7 years ago

For some reason the pasted bq query gave me an error for the json payload item. Deleting, and then inserting it from the schema list, it stopped giving the error and finally ran.

Zoltan P. · Reviewed about 7 years ago

Maxwell P. · Reviewed about 7 years ago

Senda G. · Reviewed about 7 years ago

Akinbola F. · Reviewed about 7 years ago

Les A. · Reviewed about 7 years ago

Jevon W. · Reviewed about 7 years ago