Multi Cloud Architect, Security Specialist

Use JSON Extract  - JSON_EXTRACT SELECT REGEXP_EXTRACT(, '^projects/+/datasets/(+)/tables') AS datasetRef, COUNTIF(JSON_EXTRACT(, "$.tableDataRead") IS NOT NULL) AS dataReadEvents, FROM * WHERE JSON_EXTRACT(, "$.tableDataRead") IS NOT NULL GROUP BY datasetRef ORDER BY…