Using BigQuery and Cloud Logging to Analyze BigQuery Usage Reviews

I prefer short labs since they tend to be less overwhelming, however would've been better if the queries were dissected a little and explained the purpose in more depth rather than just copy/paste. ex: CREATE OR REPLACE VIEW bq_logs.v_querylogs AS SELECT resource.labels.project_id, protopayload_auditlog.authenticationInfo.principalEmail, protopayload_auditlog.servicedata_v1_bigquery.jobCompletedEvent.job.jobConfiguration.query.query, protopayload_auditlog.servicedata_v1_bigquery.jobCompletedEvent.job.jobConfiguration.query.statementType, protopayload_auditlog.servicedata_v1_bigquery.jobCompletedEvent.job.jobStatus.error.message, protopayload_auditlog.servicedata_v1_bigquery.jobCompletedEvent.job.jobStatistics.startTime, protopayload_auditlog.servicedata_v1_bigquery.jobCompletedEvent.job.jobStatistics.endTime, TIMESTAMP_DIFF(protopayload_auditlog.servicedata_v1_bigquery.jobCompletedEvent.job.jobStatistics.endTime, protopayload_auditlog.servicedata_v1_bigquery.jobCompletedEvent.job.jobStatistics.startTime, MILLISECOND)/1000 AS run_seconds, protopayload_auditlog.servicedata_v1_bigquery.jobCompletedEvent.job.jobStatistics.totalProcessedBytes, protopayload_auditlog.servicedata_v1_…

Rasam S. · Reviewed yaklaşık 7 yıl ago

Jia Y. · Reviewed yaklaşık 7 yıl ago

Dario P. · Reviewed yaklaşık 7 yıl ago

Anh N. · Reviewed yaklaşık 7 yıl ago

Ankit H. · Reviewed yaklaşık 7 yıl ago

Kutlay K. · Reviewed yaklaşık 7 yıl ago

Kutlay K. · Reviewed yaklaşık 7 yıl ago

Jayan M. · Reviewed yaklaşık 7 yıl ago

Hung N. · Reviewed yaklaşık 7 yıl ago

Richard S. · Reviewed yaklaşık 7 yıl ago

Huy T. · Reviewed yaklaşık 7 yıl ago

Thuan N. · Reviewed yaklaşık 7 yıl ago

Eran S. · Reviewed yaklaşık 7 yıl ago

Fady I. · Reviewed yaklaşık 7 yıl ago

Lộc M. · Reviewed yaklaşık 7 yıl ago

柏硯 程. · Reviewed yaklaşık 7 yıl ago

Intense but dense

Farid B. · Reviewed yaklaşık 7 yıl ago

Thien H. · Reviewed yaklaşık 7 yıl ago

Tiger R. · Reviewed yaklaşık 7 yıl ago

Hieu N. · Reviewed yaklaşık 7 yıl ago

Ramsey T. · Reviewed yaklaşık 7 yıl ago

Guru Charan K. · Reviewed yaklaşık 7 yıl ago

Jian Jang C. · Reviewed yaklaşık 7 yıl ago

Jian Jang C. · Reviewed yaklaşık 7 yıl ago