bigquery-utils icon indicating copy to clipboard operation
bigquery-utils copied to clipboard

Errors while creating the BigQuery audit logs view

Open MonicaPC1 opened this issue 4 years ago • 1 comments

Hello, Following the step by step tutorial (https://github.com/GoogleCloudPlatform/bigquery-utils/tree/master/views/audit) when running the 'gcloud alpha logging sinks create' with the provided filter, the result is that the sink is created but the tables "cloudaudit_googleapis_com_data_access" and "cloudaudit_googleapis_com_activity" are not created in the mentioned dataset.

Running the same command without the filter is creating the 2 tables.

MonicaPC1 avatar Jan 20 '21 22:01 MonicaPC1

Will need to update README with the setup instructions required for running the query_audit.sql file. The current README only explains the setup needed for creating a logging sink related to BigQuery scripts (multi-statement queries).

danieldeleo avatar Jan 22 '21 16:01 danieldeleo