BigQuery Optimizations
Secure Google Cloud Billing Analytics with BigQuery and Looker Studio Cloud billing data deserves the same care as other sensitive enterprise data. It can reveal infrastructure usage, negotiated…
Archive
Category: BigQuery
GCP logs JSON Extract – Load into BigQuery
Use JSON Extract – JSON_EXTRACT protopayload_auditlog.metadataJsontableDataRead SELECT REGEXP_EXTRACT(protopayload_auditlog.resourceName, ‘^projects/[^/]+/datasets/([^/]+)/tables’) AS datasetRef, COUNTIF(JSON_EXTRACT(protopayload_auditlog.metadataJson, “$.tableDataRead”) IS NOT NULL) AS dataReadEvents, FROM myproject.cloudaudit_googleapis_com_data_access_2019* WHERE JSON_EXTRACT(protopayload_auditlog.metadataJson, “$.tableDataRead”) IS NOT NULL GROUP BY…