Bigquery SQL query for VPC Service control

[arun kumar]

Hi team,

Hope you are good.

I have below problem statement

I have logs which dumped in the bigquery . I need to query the log relate to VPC SERVICE CONTROL .

For example 

I have created the dry-mode for VPC-service control,where i have restricted for cloud storage .I need find the logs in bigquery which is denied by service control policies.

Can you help on this .

Thanks

Arun  

[Joaquim Pla]

Hello,

You will find more information about the audit logging with VPC Service Controls in this link from the documentation [1]. As stated in there, "The content of the audit log is available on a per project basis in the Google Cloud Console. The VPC Service Controls audit log is written into the "Audited Resource" logging stream and is available in Cloud Logging.".  If you need further help on troubleshooting VPC Service Control errors you should take a look at the trobuleshooting section for VPC Service Control errors [2].

If you would like to query those logs in BigQuery, you should export them to BigQuery defining a BigQuery log sink [3]. You will have further information about logs exports in this link from the docs [4].

[1]: https://cloud.google.com/vpc-service-controls/docs/audit-logging

[2]: https://cloud.google.com/vpc-service-controls/docs/troubleshooting#vpc-sc-errors

[3]: https://cloud.google.com/bigquery/docs/reference/auditlogs#stackdriver_logging_exports
[4]: https://cloud.google.com/logging/docs/export