-
Effects of transitioning to a paid BigQuery service from the BQ sandbox regarding data limit and export options
Hey, I’m thinking about upgrading from BigQuery’s Sandbox to their paid service. Right now, I’m seeing a 60 day limit on data. Will that go away if I switch to the paid version? Oh, and another thing, will I be able to grab all of my GA4 data from the last year or more once I’ve switched to the paid version?
-
2 Replies
-
Absolutely. Upgrading to the paid version of BigQuery does allow you an extended data retention period, although it doesn’t automatically change from the 60-day limit. You might have to manually adjust this.
As for your GA4 data, it’s a bit tricky. Past GA4 data isn’t retroactive or backfilled. This essentially means that historical data from more than 60 days back won’t all of a sudden become available once you upgrade. From the day you start your paid BigQuery service, more data will start to be accumulated, but it won’t reach back to fetch the older data. You’ll begin having access to data from the point of upgrade forward.
-
Upgrading to the paid version will eliminate the 60 day limit, allowing you to retain data for as long as you need. However, past GA4 data might not be available if it wasn’t previously linked to BigQuery, since GA4 data is not retroactively populated into BigQuery once the link is established. You can start collecting data from the day you link GA4 to BigQuery moving forward.
Log in to reply.