Published inGoogle Cloud - CommunityExamining BigQuery query performance with Row Level SecurityWhen using BigQuery Row Level Security, there is a risk of accidentally exposing information that might not be desired. Google has plugged…Jan 26A response icon1Jan 26A response icon1
Published inGoogle Cloud - CommunityBigQuery External Tables with JSON dataI recently had a BigQuery puzzle involving JSON data files and being able to query their content where the field names of the JSON objects…Sep 24, 2024Sep 24, 2024
Published inGoogle Cloud - CommunityDatastream and BigQuery — Append mode experimentsIn this article we illustrate some recipes for processing Datastream append mode change tables.Aug 29, 2024Aug 29, 2024
Published inGoogle Cloud - CommunityProcessing arriving GCS files with PubSub triggersThe article describes experiments in processing Google Cloud Storage (GCS) files through BEAM where the content is to be inserted into…Aug 12, 2024A response icon1Aug 12, 2024A response icon1
Published inGoogle Cloud - CommunityDynamic temporal correlations using BigQueryThe story described in this article is one that a colleague brought as a puzzle. I tried to find a solution and they themselves came up…Jul 28, 2024A response icon1Jul 28, 2024A response icon1
Published inGoogle Cloud - CommunityDe-identifying BigQuery data using SDPOne of the many Google Cloud services is called Sensitive Data Protection (SDP). The purpose of this service is to find sensitive data…Jul 7, 2024Jul 7, 2024
Published inGoogle Cloud - CommunityCloud Trace spanning PubSubTracing across PubSub (or other asynchronous action)May 30, 2024May 30, 2024
Published inGoogle Cloud - CommunityBigQuery and Privacy PoliciesWhen thinking about published data and its privacy considerations, we also have to think about how an adversary might use the nature of the…Sep 10, 2023Sep 10, 2023
Published inGoogle Cloud - CommunityDialogflow and Service DirectoryWhen using Dialogflow CX we often wish to invoke a Webhook backend to either dynamically retrieve some information or perform an action as…Aug 28, 2023A response icon2Aug 28, 2023A response icon2
Published inGoogle Cloud - CommunityPreventing prod access with IAM ConditionsHow to prevent production from inheriting Google Cloud organization roles.Mar 13, 2023A response icon1Mar 13, 2023A response icon1