GoogleCloudPlatform / bigquery-utils

Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.
https://cloud.google.com/bigquery/
Apache License 2.0
1.12k stars 281 forks source link

Errors while creating the BigQuery audit logs view #214

Open MonicaPC1 opened 3 years ago

MonicaPC1 commented 3 years ago

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.

danieldeleo commented 3 years ago

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).