Create a new logger sink for BigQuery

1. Navigate to the Logging service, as shown below.

2. Click Logs Router.

3. Click CREATE SINK.

4. Enter a general sink name: Umbrella-big-query-audit and click Next.
5. Create a Dataset.
6. 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.

7. Click PREVIEW LOGS to validate that logs are retrieved.
8. Click NEXT.
9. Click CREATE SINK.

Retrieve Table Details

1. Navigate to the BigQuery Service.

2. From the Explorer menu, click the relevant table DETAILS tab and provide us with the Table ID.