Description:


Some times we need to access the Big Query audit logs to debug issues related to Big query export in Infoworks ADE. We can use bq command line tool installed on Infoworks edge node or on any other machine to access the audit logs.


Here are the commands that will help in getting the BigQuery audit logs.


bq ls -j <project_name> This command will list all the audit logs for a particular BigQuery Project.



bq show --format=prettyjson -j <project_name>:<log_file_name> This command will pretty print the content of a particular audit log of a BigQuery project



Go through the below link for more information on bq command line tool.


https://cloud.google.com/bigquery/docs/reference/bq-cli-reference