How to extract real-time intraday data from Google Analytics 4 and Firebase in BigQuery

solution to improve data availability with *Firebase or Google Analytics 4 integrations

If you are a Firebase or Google Analytics 4 user and you have setup data imports into your BigQuery data warehouse then you might want to create real-time custom reports with your data in intraday schema. The problem is that this integrated dataset is being deleted automatically by Google every day. So if you choose to connect it as a datasource to your report in Google Data Studio you won't find it the day after.

Here is the solution to improve data availability with *Firebase or Google Analytics 4 integrations.

https://mydataschool.com/blog/how-to-extract-real-time-intraday-data-in-firebase-and-bigquery/