Documentation
Start typing to search…

Connect BigQuery Audit Logs

This article describes how to connect with BigQuery audit logs. BigQuery information is used for retrieving information of cost metrics.

Create a new logger sink for BigQuery

  1. Navigate to the Logging service, as shown below.
  1. Click Logs Router.
  1. Click CREATE SINK.
  1. Enter a general sink name: Umbrella-big-query-audit and click Next.
  2. Create a Dataset.
  3. Filter the logs to include using the following filter:
    resource.type="bigquery_resource" logName="projects/[PROJECT_ID]/logs/cloudaudit.googleapis.com%2Fdata_access" where [PROJECT_ID] should be replaced with your project ID.
  1. Click PREVIEW LOGS to validate that logs are retrieved.
  2. Click NEXT.
  3. Click CREATE SINK.

Retrieve Table Details

  1. Navigate to the BigQuery Service.
  1. From the Explorer menu, click the relevant table DETAILS tab and provide us with the Table ID.

Updated 9 months ago