GA4 (360) +BigQuery+CDC

[mharitakis]

Hello,

i export data from Google analytics to BigQuery, by default 4 tables have been created, can i enable the CDC in BigQuery tables and identify the new rows appended on the tables?

Thanks

[NorieRam]

Hi @mharitakis,

Welcome to Google Cloud Community!

Currently, BigQuery change data capture (CDC) cannot be directly enabled on existing BigQuery tables that were initially populated via a bulk load from a Google Analytics 4 export. This is because CDC requires data to be ingested through the BigQuery Storage Write API, and the initial GA4 export does not use this method.

Here’s a valuable insight from Stackoverflow forum that is related to your question.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to he