About DataEngineer_1

DataEngineer_1 · 09-25-2023

We have recently observed that the scheduled email delivery option just stopped sending emails to any group email ID's or Lists within Google Workspace. This means that a lot of analytics reports which were being sent out to our business users just s...

DataEngineer_1 · 08-03-2023

We are using Google Looker Studio to render some enterprise analytics reports for our stakeholders. We utilise the schedule delivery feature to send email notifications to the report users that the reports are refreshed with data and are ready for vi...

DataEngineer_1 · 06-20-2022

Hi All, I am using BigQuery as a target for CDC implementation where I am using Debezium to pull the CDC records from a source database. For all inserts we are using the BigQuery streaming insert feature as it is very fast in comparison to the standa...

DataEngineer_1 · 01-11-2024

I found that my organization's email policy does not allow external email domains to send emails to organization groups unless they are whitelisted. Looker studio schedule emails usually come from looker-studio-noreply @ google.com accountThis whitel...

DataEngineer_1 · 08-22-2023

Hi, Thanks for sharing the Private IP option. Can I check if we are able to connect to a CloudSQL inside one GCP Project from a BigQuery in a different GCP Project?Or this would need some sort of VPC peering to be enabled?

DataEngineer_1 · 08-03-2023

Thanks for your prompt response. This is very helpful !

DataEngineer_1 · 08-03-2023

Hi,Thanks for your inputs.By any chance can we bypass this requirement to use the Public IP enabled on the Cloud SQL instance? Our Application team has decided to disable this option considering it a security risk and since our pipeline was using the...

DataEngineer_1 · 06-20-2022

Thanks for sharing this!Could you help show how the records look like on BigQUery side? I would also like to understand how the UPDATES & DELETES are being handled? I was unable to find DataFlow job templates which could support streaming data loads ...

My Stats

EduardoDeLeonV's Bio

Badges DataEngineer_1 Earned

Recent Activity

Looker Studio Scheduled Delivery not sending to Lists/Groups

Looker Studio Scheduled Email Deliveries Delayed

BigQuery Streaming Buffer Manipulation

Re: Looker Studio Scheduled Delivery not sending to Lists/Groups

Re: how to secure the connection between bigquery and cloudsql

Re: Big Query can't connect to Cloud SQL

Re: Big Query can't connect to Cloud SQL

Re: Replicating Oracle data in BigQuery for real-time and automated insights